Share via

XmlMap.ExportXml Method

  • Article
Excel Developer Reference

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

Syntax

expression.ExportXml(Data)

expression   A variable that represents a XmlMap object.

Parameters

Name Required/Optional Data Type Description
Data Required String The variable to export the data to.

Return Value
XlXmlExportResult

Remarks

XlXmlExportResult can be one of the following XlXmlExportResult constants.
xlXmlExportSuccess . Export successful. No errors to report.
xlXmlExportValidationFailed . The data being exported failed schema validation, but was exported anyway.

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

Example

The following example exports the contents of the cells mapped to the "Contacts" schema map to a variable named strContactData.

Visual Basic for Applications 
  Sub ExportToString()
    Dim strContactData As String

ActiveWorkbook.XmlMaps("Contacts").<strong>ExportXml</strong> Data:=strContactData



End Sub

See Also