WorkbookBeforeXmlExport Event

Note  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.

Occurs before Microsoft Excel saves or exports data from any open workbook to an XML data file.

expression.WorkbookBeforeXmlExport(Wb, Map, Url, Cancel)

expression    Required. An expression that returns an Application object.

Wb    Required Workbook. The target workbook.

Map    Required XmlMap. The XML map that will be used to save or export data.

Url    Required String. The location of the XML file to be exported.

Cancel    Required Boolean. Set to True to cancel the save or export operation.

Remarks

Use the BeforeXmlExport event if you want to capture XML data that is being exported or saved from a particular workbook.