Export Method

Applies To

Chart object.

Description

Exports the chart in a graphic format.

Syntax

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.

Charts(1).Export _
    OutputFileName:="current_sales.gif", FilterName:="GIF"