Application.WorkbookAfterXmlImport Event (Excel)
Occurs after an existing XML data connection is refreshed, or new XML data is imported into any open Microsoft Excel workbook.
Syntax
식 .WorkbookAfterXmlImport(Wb, Map, IsRefresh, Result)
식 A variable that represents an Application object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
---|---|---|---|
Wb |
필수 |
The target workbook. |
|
Map |
필수 |
The XML map that was used to import data. |
|
IsRefresh |
필수 |
Boolean |
True if the event was triggered by refreshing an existing connection to XML data, False if a new mapping was created. |
Result |
필수 |
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.