XmlMap.Import method (Excel)
Imports data from the specified XML data file into cells that have been mapped to the specified XmlMap object.
expression.Import (Url, Overwrite)
expression A variable that represents an XmlMap object.
|Url||Required||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.|
|Overwrite||Optional||Variant||Set to True to overwrite existing data. Set to False to append to existing data. The default value is False.|
An XlXmlImportResult value that indicates the result of the method.
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):
- If the XML data contains syntactical errors.
- If the import is cancelled because not all the data could fit on the worksheet.
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.