WorkbookEvents_Event.BeforeXmlImport EventĀ 

Occurs before an existing XML data connection is refreshed or before new XML data is imported into a Microsoft Excel workbook.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)

Usage

WithEvents workbookEvents_Event1 As WorkbookEvents_Event
Function workbookEvents_Event1_BeforeXmlImport(Map As XmlMap, _
    Url As String, _
    IsRefresh As Boolean, _
    Cancel As Boolean) As Void
    Handles workbookEvents_Event1.BeforeXmlImport
End Function

Syntax

Event BeforeXmlImport As WorkbookEvents_BeforeXmlImportEventHandler
event WorkbookEvents_BeforeXmlImportEventHandler BeforeXmlImport;
event WorkbookEvents_BeforeXmlImportEventHandler^ BeforeXmlImport;
 void add_BeforeXmlImport(WorkbookEvents_BeforeXmlImportEventHandler handler);
 void remove_BeforeXmlImport(WorkbookEvents_BeforeXmlImportEventHandler handler);
In JScript, you can handle the events defined by a class, but you cannot define your own.

Remarks

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

WorkbookEvents_Event Interface
Microsoft.Office.Interop.Excel Namespace

Other Resources

WorkbookEvents_Event Members