Link to home
Create AccountLog in
Avatar of Karmile
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
ASKER CERTIFIED SOLUTION
Avatar of Phillip Burton
Phillip Burton

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Karmile
Karmile

ASKER

Perfect!  Thank you Phillip.