| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
Workbook.BeforeXmlImport event (Excel) |
vbaxl10.chm503097 |
|
|
a0a589c6-15f9-5599-c0b6-c6f881816ad6 |
05/29/2019 |
medium |
Occurs before an existing XML data connection is refreshed or before new XML data is imported into a Microsoft Excel workbook.
expression.BeforeXmlImport (Map, Url, IsRefresh, Cancel)
expression A variable that represents a Workbook object.
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Map | Required | XmlMap | The XML map that is 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. |
Nothing
[!includeSupport and feedback]