Hi there,

I was wondering if there was a way within VBA to refresh an XML Schema.
I have a report with 20 schemes within a spreadsheet and the xml data is
replaced each week so that all you have to do is refresh the data to update
it.

I'm awaire of something that can be done with the XML Toolbox but out IT
team will not allow this to be installed.

Please advise if this can be done with VBA which would allow the report to
be fully automated!

Thanks
Paulw