AppEvents_Event.WorkbookBeforeXmlImport Event
Occurs before an existing XML data connection is refreshed or new XML data is imported into any open Microsoft Excel workbook.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Event WorkbookBeforeXmlImport As AppEvents_WorkbookBeforeXmlImportEventHandler
'Usage
Dim instance As AppEvents_Event
Dim handler As AppEvents_WorkbookBeforeXmlImportEventHandler
AddHandler instance.WorkbookBeforeXmlImport, handler
event AppEvents_WorkbookBeforeXmlImportEventHandler WorkbookBeforeXmlImport
Remarks
Use the BeforeXmlImport event if you want to capture XML data that is being imported or refreshed to a particular workbook.
XML features, except for saving files in the XML Spreadsheet format, are available only in Microsoft Office Professional Edition 2003 and Microsoft Office Excel 2003.