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.
|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.|