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)
Usage
WithEvents appEvents_Event1 As AppEvents_Event
Function appEvents_Event1_WorkbookBeforeXmlImport(Wb As Workbook, _
Map As XmlMap, _
Url As String, _
IsRefresh As Boolean, _
Cancel As Boolean) As Void
Handles appEvents_Event1.WorkbookBeforeXmlImport
End Function
Syntax
Event WorkbookBeforeXmlImport As AppEvents_WorkbookBeforeXmlImportEventHandler
event AppEvents_WorkbookBeforeXmlImportEventHandler WorkbookBeforeXmlImport;
event AppEvents_WorkbookBeforeXmlImportEventHandler^ WorkbookBeforeXmlImport;
void add_WorkbookBeforeXmlImport(AppEvents_WorkbookBeforeXmlImportEventHandler handler);
void remove_WorkbookBeforeXmlImport(AppEvents_WorkbookBeforeXmlImportEventHandler handler);
In JScript, you can handle the events defined by a class, but you cannot define your own.
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.
Platforms
Development Platforms
Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000
Target Platforms
See Also
Reference
AppEvents_Event Interface
Microsoft.Office.Interop.Excel Namespace