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
식 .BeforeXmlImport(Map, Url, IsRefresh, Cancel)
식 A variable that represents a Workbook object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Map |
필수 |
The XML map that will be used to import data. |
|
Url |
필수 |
String |
The location of the XML file to be imported. |
IsRefresh |
필수 |
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 |
필수 |
Boolean |
Set to True to cancel the import or refresh operation. |
Return Value
Nothing