Karmile
asked on
Import Filename with XML data in Excel
I have 1000's of XML files that I can import into a single Excel 2007 sheet. The problem is that the file name is the unique identifier and I need to import this together with the XML data. I have attached the XMLImport.xlsm which has the code to import multiple XML files. The part which is missing is the file name. Any assistance would be greatly appreciated.
XMLImport.xlsm
135878.xml
985658.xml
XMLImport.xlsm
135878.xml
985658.xml
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER