name of XML map

**nickTokyo** · 04-13-2009, 11:20 PM

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

Dim xmpCustomMap As XmlMap
Set xmpCustomMap = ActiveWorkbook.XmlMaps("ROOT_Map")
ActiveWorkbook.XmlImport URL:="S:\Path\to\file\153MTA.XML", ImportMap:=xmpCustomMap, Overwrite:=True

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** · 04-13-2009, 11:32 PM

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).