ExportXML Method
As it applies to the DataSourceControl object.
Saves the current recordset as an XML file.
expression.ExportXML(eEncoding)
expression Required. An expression that returns a DataSourceControl object.
eEncoding Optional DscEncodingEnum. The format in which schema information is exported. If this argument is omitted, schema information is embedded in the data document.
| DscEncodingEnum can be one of these DscEncodingEnum constants. |
| dscUTF16 |
| dscUTF8 default |
Remarks
Use the XMLLocation property to set whether the data is exported to an XML data island or a separate XML data file. Use the XMLDataTarget property to specify the path or ID to use when exporting the data.
As it applies to the XmlMap object.
Saves the data in the specified schema map to an XML data stream.
expression.ExportXML(ShowDialogs)
expression Required. An expression that returns an XmlMap object.
ShowDialogs Optional Boolean. Specifies whether a dialog box is displayed if the ExportXML method encounters an error that is returned by the Spreadsheet component itself. When ShowDialogs is set to True, a dialog box is displayed if the ExportXML method encounters an error returned by the Spreadsheet component. When ShowDialogs is set to False, dialog boxes for Spreadsheet component errors are not displayed. The default is False.
Note The ShowDialogs argument does not control whether a dialog box will be displayed for errors external to the Spreadsheet component, such as errors returned by scripting components. To prevent a dialog box from displaying for errors external to the Spreadsheet component, you must trap those errors in your script.
Remarks
If the ExportXml method is called on an XmlMap object while an asynchronous binding is in progress, a run-time error will occur. You can determine if a data binding is asynchronous by using the Async property of the XmlDataBinding object. You can determine whether a binding is in progress by using the BindingInProgress property of the XmlDataBinding object.
Example
As it applies to the DataSourceControl object.
This example exports the current data in the data source control named MSODSC to an XML data file.
Sub ExportData()
Dim dscConstants
Set dscConstants = MSODSC.Constants
' Set the location of the XML data to a data file.
MSODSC.XMLLocation = dscConstants.dscXMLDataFile
' Set the specific target to export to.
MSODSC.XMLDataTarget = "Q1 Sales Analysis.xml"
' Export the current data.
MSODSC.ExportXML
End Sub