Workbook.AfterXmlImport Event
| Excel Developer Reference |
Occurs after an existing XML data connection is refreshed or after new XML data is imported into the specified Microsoft Excel workbook.
Syntax
expression.AfterXmlImport(Map, IsRefresh, Result)
expression A variable that represents a Workbook object.
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| Map | Required | XmlMap | The XML map that will be used to import data. |
| IsRefresh | Required | Boolean | True if the event was triggered by refreshing an existing connection to XML data; False if the event was triggered by importing from a different data source. |
| Result | Required | XlXmlImportResult | Indicates the results of the refresh or import operation. |
Return Value
Nothing
Remarks
| XlXmlImportResult can be one of the following XlXmlImportResult constants: |
| 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. |
See Also