Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Workbook.SaveAsXMLData Method

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


expression.SaveAsXMLData(Filename, Map)

expression   A variable that represents a Workbook object.


NameRequired/OptionalData TypeDescription
FilenameRequiredStringA 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.
MapRequiredXmlMapThe schema map to apply to the data.


This method will result 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.


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".

Visual Basic for Applications
Sub ExportAsXMLData()
    Dim objMapToExport As XmlMap
    Set objMapToExport = ActiveWorkbook.XmlMaps("Customer")
    If objMapToExport.IsExportable Then

        ActiveWorkbook.SaveAsXMLData "Customer Data.xml", objMapToExport
        MsgBox "Cannot use " & objMapToExport.Name & _
               "to export the contents of the worksheet to XML data."
    End If
End Sub

Community Additions

© 2015 Microsoft