Export Method [Excel 2003 VBA Language Reference]
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.
XlXmlExportResult
| XlXmlExportResult can be one of the following XlXmlExportResult constants: |
| xlXmlExportSuccess Export successful. No errors to report. |
| xlXmlExportValidationFailed The data being exported failed schema validation, but was exported anyway. |
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"
Applies to | Chart Object | XmlMap Object