Workbook BeforeXmlExport Event

Syntax
Private Sub Workbook_BeforeXmlExport(ByVal Map As XmlMap, ByVal Url As String, Cancel As Boolean)
Enter Code
End Sub

This event will run before Excel saves or exports XML data from this specific workbook.

Required Parameters
Map
The map parameter returns the map that is being saved or exported as an XMLMap object.  This parameter can be used to manipulate the XML map object and its properties.

Url
The url parameter returns location of where the XML map will be saved as a string.

Cancel
The cancel parameter is original set to False when the event begins. If the cancel parameter is set to value of True then the workbook will not save or export the XML map.