Occurs before an existing XML data connection is refreshed, or new XML data is imported into any open Microsoft Excel workbook.
Syntax
expression.WorkbookBeforeXmlImport (Wb, Map, Url, IsRefresh, Cancel)
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 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 a new mapping will be created. |
| Cancel | Required | Boolean | Set to True to cancel the import or refresh operation. |
Return value
Nothing
Remarks
Use the BeforeXmlImport event of the Workbook object if you want to capture XML data that is being imported or refreshed to a particular workbook.