name of XML map

[nickTokyo]

Hi,

I have an excel sheet I made by opening a XML file using the "view source" option. From there I made a map and build a macro off that.

What I want to do is convert it to allow the user to select which XML file to load into the map. I found the following code at technet

Please Login or Register  to view this content.

However I'm not sure how to get the name of the XML map, referred to as ROOT_Map whan I made it "manually" by opening the file.

Any ideas?

Thanks,

Nick


EDIT: Here is the page to which I was referring... http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

[ffffloyd]

As with any Collection of objects in VBA, you can retrieve them by index if the name is unavailable. To retrieve the root XmlMap then you'd say ActiveWorkbook.XmlMaps(1).

[nickTokyo]

thanks! that works