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.

Syntax

expression.SaveAsXMLData(Filename, Map)

expression   A variable that represents a Workbook object.

Parameters

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.

Remarks

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.

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

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
    Else
        MsgBox "Cannot use " & objMapToExport.Name & _
               "to export the contents of the worksheet to XML data."
    End If
End Sub



Community Additions

ADD
Show:
© 2015 Microsoft