Hello MsOfficeForums



I need to import multiple XML files into a single Excel Sheet programatically. I need to do this via code, because I need to append a column to the end of each row that indicates the file name that data came from.

So, I need help, 1) I tried using Workbooks.OpenXML , but that opens a new workbook . I need to loop through all xml files in a folder into 1 worksheet. and after each file update a column with the file name.

So I think this is what i need to do...-
1) I have one file imported already so I have the mapping already.

2) write code to get a file list to loop through
3) import a xml file from the file list, then update a column with that file name
4) go to the bottom of the sheet
5) repeat steps 3 & 4 until all files are imported

Thoughts,

many thanks...