Workbook.BeforeXmlImport Event
Occurs before an existing XML data connection is refreshed or before new XML data is imported into a Microsoft Excel workbook.
Syntax
expression.BeforeXmlImport(Map, Url, IsRefresh, Cancel)
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. |
| Url | Required | String | The location of the XML file to be imported. |
| 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. |
| Cancel | Required | Boolean | Set to True to cancel the import or refresh operation. |
Return Value
Nothingbefore importing xml into excel before xml import event beforexml beforexmlimport beforexmlimport event workbook_beforexmlimport