Share via


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.

See Also

Reference

AppEvents_Event Interface

AppEvents_Event Members

Microsoft.Office.Interop.Excel Namespace