Export Method

Microsoft Excel Visual Basic

Export Method

       

Exports the chart in a graphic format.

expression.Export(FileName, FilterName, Interactive)

expression   Required. An expression that returns a Chart object.

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

Example

This example exports chart one as a GIF file.

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