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