I started of by using the code that was created in a macro - but realized now that the with - end with block is not used on repeat imports anyway or rather has no use. SRange = '$A$' & (Cells(Rows.Count, 'A').End(xlUp).Row + 1)ĪctiveWorkbook.XmlImport URL:=sXMLFile, ImportMap:=Nothing, Overwrite:=Not bolAppend, Destination:=Range(sRange) ShowImportExportValidationErrors = False With ActiveWorkbook.XmlMaps(sWorksheet & '_Map') Warning = MsgBox('Warning! The worksheet ' & sWorksheet & ' will be deleted and all data therein lost.

Do you want to append the data to the existing sheet?', vbYesNoCancel) Response = MsgBox('Worksheet already exist. Files are appended in a vertical fashion. These instructions were created using Internet Explorer 7.0. Simply specify local XML files and whether to add all to one sheet or to create a new sheet for each file. Introduction: This document explains how to take XML data and load that data into Microsoft Excel. MySheetNameTest = Worksheets(sWorksheet).Name Excel Import Multiple XML Files Software offers a solution to users who want to work with multiple XML files simultaneously. This is what I got so far: Sub ImportXML(sWorksheet, sXMLFile, bolAppend)ĭim mySheetNameTest, Response, Warning, sRange I'm not even able to do such an import 'manually' though either - importing XML and have a new table created and then importing another XML with the same format (different date) into the same table. I am able to import the data onto the same sheet, however each import results in a separate table. I'm trying to solve the same problem and have tried various approaches playing around with the different XMLImport parameters, but no success.

Excel import xml from url