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 .excelforum.com/excel-programming-vba-macros/365573-record-macro-to-export-xml.html, 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.
Thanks
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 .excelforum.com/excel-programming-vba-macros/365573-record-macro-to-export-xml.html, 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.
Thanks