| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
Application.WorkbookBeforeXmlImport event (Excel) |
vbaxl10.chm504098 |
|
|
33c7f386-9eec-6ba4-519e-9480ab2f5a31 |
04/05/2019 |
medium |
Occurs before an existing XML data connection is refreshed, or new XML data is imported into any open Microsoft Excel workbook.
expression.WorkbookBeforeXmlImport (Wb, Map, Url, IsRefresh, Cancel)
expression A variable that represents an Application object.
| 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. |
Nothing
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.
[!includeSupport and feedback]