Hi,
I have columns A to AA filled with data down to row 7 with the headers always being in the first row. What I am trying to do is to load the XML map from an XML file, then assigning each element in the XML maps to a certain column and then exporting that XML file. I want to do all this is all in VBA. I was able to find out what the code is to load in the XML map using the macro recorder:
However, when I started assigning the elements of the map, the macro recorder did not record anything. Can anyone tell me what kind of code I would need to use to assign the elements of the map to the columns (first element to the first column, second element to the second column, etc, with the headers of the columns and the name of the elements always being the same)? I would really appreciate any kind of help!
I have columns A to AA filled with data down to row 7 with the headers always being in the first row. What I am trying to do is to load the XML map from an XML file, then assigning each element in the XML maps to a certain column and then exporting that XML file. I want to do all this is all in VBA. I was able to find out what the code is to load in the XML map using the macro recorder:
HTML:
Sub Macro1()
ActiveWorkbook.XmlMaps.Add( _
"\\vpnlfap00844\udv00844\m05e610\Desktop\xml_pos_sample.xml", "posFile"). _
Name = "posFile_Map1"
End SubHowever, when I started assigning the elements of the map, the macro recorder did not record anything. Can anyone tell me what kind of code I would need to use to assign the elements of the map to the columns (first element to the first column, second element to the second column, etc, with the headers of the columns and the name of the elements always being the same)? I would really appreciate any kind of help!
