XmlMap.Import (Excel)

Imports data from the specified XML data file into cells that have been mapped to the specified XmlMap object. Possible return values are xlXmlImportElementsTruncated - The contents of the specified XML data file have been truncated because the XML data file is too large for the worksheet, xlXmlImportSuccess - The XML data file was successfully imported, xlXmlImportValidationFailed - The contents of the XML data file do not match the specified schema map.

If either of the following conditions is True, a run-time error occurs. If more than one condition is True, Excel returns a run-time error for the most severe (they are listed with the most severe listed first):

Import (Url, Overwrite)

Dim strUrl As String: strUrl = 
Dim xxiImport As XlXmlImportResult
xxiImport = ActiveWorkbook.XmlMaps(1).Import(Url:=strUrl)

Arguments

The following argument is required

Url (String) - The path to the XML data to import. The path can be specified in Universal Naming convention (UNC) or Uniform Resource Locator (URL) format. The file can be an XML data file.

Optional arguments

The following argument is optional

Overwrite (Boolean) - Set to True to overwrite existing data. Set to False to append to existing data. The default value is False.