Occurs before Microsoft Excel saves or exports XML data from the specified workbook.
Syntax
expression.WorkbookBeforeXmlExport (Wb, Map, Url, Cancel)
expression A variable that represents an Application object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| 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. |
Return value
Nothing
Remarks
Use the BeforeXmlExport event of the Workbook object if you want to capture XML data that is being exported or saved from a particular workbook.