Excel.XmlMap.ExportXml.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
XmlMap.ExportXml method (Excel)	vbaxl10.chm754090	vbaxl10.chm754090	Excel.XmlMap.ExportXml	ffb4e656-157e-e5f3-1ddd-314172ba5839	05/21/2019	medium

XmlMap.ExportXml method (Excel)

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

Syntax

expression.ExportXml (Data)

expression A variable that represents an XmlMap object.

Parameters

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

Return value

XlXmlExportResult

Remarks

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.

Sub ExportToString() 
 Dim strContactData As String 
 
 ActiveWorkbook.XmlMaps("Contacts").ExportXml Data:=strContactData 
End Sub

[!includeSupport and feedback]