Macroing XML maps in Excel


New member
Oct 9, 2013
Reaction score
Hi all.

I'm trying to write a macro that loads the XML map that I have for each table in a workbook, them applies the XML map, and them exports the XML to given location.

I can do the first part and I can export them and name as I want, however the only thing I can't do is work out how to write in the macro where to and apply the XML map.

I tried searching and came up with a link on this forum, www, however I don't know how to use this within the code as I'm not a VBA expert. What do the different parts refer to and what do I replace them with if I use ListColumn.XPath.SetValue as mentioned or is there a better way to apply the map to a certain range? I want to apply the map to everything in column B onwards, I don't want to use column A as it is there for reference only.

Hope this makes sense.