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

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