Export Method

Microsoft Excel Visual Basic

ShowExport method as it applies to the Chart object.

Exports the chart in a graphic format. Returns Boolean.

expression.Export(Filename, FilterName, Interactive)

expression    Required. An expression that returns one of the objects in the Applies To list.

Filename    Required String. The name of the exported file.

FilterName    Optional Variant. The language-independent name of the graphic filter as it appears in the registry.

Interactive    Optional Variant. Optional Variant. True to display the dialog box that contains the filter-specific options. If this argument is False, Microsoft Excel uses the default values for the filter. The default value is False.

ShowExport method as it applies to the XmlMap object.

Exports the contents of cells mapped to the specified XmlMap object to an XML data file. Returns XlXmlExportResult.

XlXmlExportResult can be one of the following XlXmlExportResult constants
xlXmlExportSuccess The XML data file was successfully exported.
xlXmlExportValidationFailed The contents of the XML data file do not match the specified schema map.
.

expression.Export(Url, Overwrite )

expression    Required. An expression that returns one of the objects in the Applies To list.

Url    Required String. The path and filename of the XML data file to export to.

Overwrite    Required Boolean. Set to True to overwrite the file specified in the URL    parameter if the file exists. The default value if False.

Remarks

Use the ExportXML method to export the contents of the mapped cells to a String variable.

Example

This example exports chart one as a GIF file.

Worksheets("Sheet1").ChartObjects(1) _
.Chart.Export _
    FileName:="current_sales.gif", FilterName:="GIF"