XlXmlImportResult enumeration (Excel)

Specifies the results of the refresh or import operation.

Name Value Description
xlXmlImportElementsTruncated 1 The contents of the specified XML data file have been truncated because the XML data file is too large for the worksheet.
xlXmlImportSuccess 0 The XML data file was successfully imported.
xlXmlImportValidationFailed 2 The contents of the XML data file don't match the specified schema map.

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.