XmlMap.ExportXml procedure builder

XmlMap.ExportXml (Excel)

Exports the contents of cells mapped to the specified XmlMap object to a String variable.

Possible Values are xlXmlExportSuccess - The XML data file was successfully exported, xlXmlExportValidationFailed - The contents of the XML data file do not match the specified schema map.

To export the contents of the mapped cells to an XML data file, use the Export method.

ExportXml (Data)

Data: The variable to export the data to.

Dim strData As String: strData = 
Dim xxeExportXml As XlXmlExportResult
xxeExportXml = ActiveWorkbook.XmlMaps(1).ExportXml(Data:=strData)