Application.WorkbookAfterXmlImport Event
Occurs after an existing XML data connection is refreshed, or new XML data is imported into any open Microsoft Excel workbook.
Syntax
expression.WorkbookAfterXmlImport(Wb, Map, IsRefresh, Result)
expression A variable that represents an Application object.
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| Wb | Required | Workbook | The target workbook. |
| Map | Required | XmlMap | The XML map that was used to import data. |
| IsRefresh | Required | Boolean | True if the event was triggered by refreshing an existing connection to XML data, False if a new mapping was created. |
| 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. |
Use the AfterXmlImport event if you want to perform an operation after XML data has been imported into a particular workbook.workbook workbook after xml import workbookafter workbookafterxml workbookafterxmlimport workbookafterxmlimport event