Export each row as a XML file, using column headings as xml field names

[hebgphsx]

I have an excel spreadsheet where row 1 is headers, then all the rows below are the data. What I need to do is export each row starting with row 2 to an individual file, name the file the value in column A for that row, but include all columns (including A) in the XML output where the field names in the XML that hold the values are the names of the header from row 1.
Is that even possible in Excel? I tried to export the whole thing as a xml spreadsheet, but that wasn't helpful as it just listed everything as <Row> and <Cell> without meaningful stuff like the column headings inside the <>

 

[Rijnsent]

Hi hebgphsx,
yes, that's probably doable with VBA. See the last example on this page to get an idea for the export setup: Working with XML files in VBA (VBA XML) - Analyst Cave For the rest you'd need some loop to loop through your data and export is, see e.g. Loop in Excel VBA
If you have some code you need feedback on, do not hesitate to post it here,
Koen