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.