Purpose
Occurs before an existing XML data connection is refreshed, or new XML data is imported into any open Microsoft Excel workbook.
Syntax
WorkbookBeforeXmlImport(Wb, Map, Url, IsRefresh, Cancel)
Required Parameters
Wb
The target workbook.
Map
The XML map that will be used to import data.
Url
The location of the XML file to be imported.
IsRefresh
True if the event was triggered by refreshing an existing connection to XML data, False if a new mapping will be created.
Cancel
Set to True to cancel the import or refresh operation.
