Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

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)

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

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.

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.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

Community Additions

© 2015 Microsoft