JustinDevine
03-13-2007, 08:08 AM
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.refresh
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!
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.refresh
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!