Workbook.BeforeXmlImport Event (Excel)
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 |
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
Nothing