Refresh All XMLMaps

[JustinDevine]

Hi,

I have a workheet with many XMLMaps / Lists. I can refresh the data of each by right clicking and selecting XML "Refresh XML Data". This produces the following VBA if a Macro is recorded

ActiveWorkbook.XmlMaps("Investment_x0020_Overview_Map4").DataBinding.refres h

In addition I can get a list of all of the XML Maps in the workbook by accessing the XML Source Window. (Data --> XML --> XML Source) This sidebar displays all of the XML maps in a dropdown as well as allowing you to create a new window by clicking the "XML Maps" button.

My question is.. How do I create a Macro that will refresh all of the XML Maps. I assume the solution would involve either getting the list of all maps and looping through it, or perhaps there is a more elegant solution. In either case I need help as I am stuck. Thanks!

[Charlize]

[VBA]activeworkbook.refreshall[/VBA] ????

[Marcster]

Microsoft has a Excel 2003 XML Toolbox:
http://www.microsoft.com/downloads/d...displaylang=en

You can, quote "Quickly refresh all XML maps with bound data sources. "
Don't know weather this would help you or not.

Marcster.