Imports data from the specified XML data file into cells that have been mapped to the specified XmlMap object.Possible 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):
Dim strUrl As String: strUrl = Dim xxiImport As XlXmlImportResult xxiImport = ActiveWorkbook.XmlMaps(1).Import(Url:=strUrl)
The following argument is required