Since you are only changing 4 values in the main xml file it is easier just to treat the file as a text file. The code works by reading a "stock standard file" called pano1.xml.txt (which I have attached) - I have altered this file so the code can find the sections that need to be replaced with data from your worksheet. Do not alter this text file as it is used to determine the replacement areas. This file is read and then the code iterates through the excel worksheet replacing the values. You will need to alter the location of the pano1.xml.txt file in the code and the output directory for the xml files. The code just generates files called pano1.xml, pano2.xml etc. The code is as follows. Workbook attached. Any problems let me know.
Bookmarks