Workbook.SaveAsXMLData method (Excel)

Exports the data that has been mapped to the specified XML schema map to an XML data file.

Syntax

expression.SaveAsXMLData (FileName, Map)

expression A variable that represents a Workbook object.

Parameters

Name	Required/Optional	Data type	Description
FileName	Required	String	A string that indicates the name of the file to be saved. You can include a full path; if you don't, Microsoft Excel saves the file in the current folder.
Map	Required	XmlMap	The schema map to apply to the data.

Remarks

This method results in a run-time error if Excel cannot export data with the specified schema map. To check whether Excel can use the specified schema map to export data, use the IsExportable property.

Example

The following example verifies that Excel can use the schema map Customer to export data, and then exports the data mapped to the Customer schema map to a file named Customer Data.xml.

Sub ExportAsXMLData() 
 Dim objMapToExport As XmlMap 
 
 Set objMapToExport = ActiveWorkbook.XmlMaps("Customer") 
 
 If objMapToExport.IsExportable Then 
 
 ActiveWorkbook.SaveAsXMLData "Customer Data.xml", objMapToExport 
 Else 
 MsgBox "Cannot use " & objMapToExport.Name & _ 
 "to export the contents of the worksheet to XML data." 
 End If 
End Sub

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.