P
Peter
In the help entry for export method, reproduced below, there is mention of
the filter specific options of the export filter, an MS Excel add-in.
Dose anyone know how to access this filter and its options programmatically?
Specifically i want to choose a resolution level for the exported pic. I am
assuming that such an option exists since there is a facility in a dialogue
box in other MS apps such as Word and Publisher which allows the user to
nominate the resolution of the object that is converted to a jpg or tif etc.
In Publisher, for example, you access this dialogue by => selecting the
object => right click => save as picture => change => and choose a radio
button to select one of four options (web 96dpi, desktop printing 150dpi,
commercial prining 300dpi and original image resolution as specified).
I would like to change this parameter or property of the MS Office add-in
called export filter. I am assuming this is the avenue for exploration since
there appears to be no property of the excel method in excel.
The entry from the F1 help listing on this method is reproduced as follows:
Export Method
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.
Example
This example exports chart one as a GIF file.
Worksheets("Sheet1").ChartObjects(1) _
..Chart.Export _
FileName:="current_sales.gif", FilterName:="GIF"
I am hoping someone will be able to help me.
thanks
the filter specific options of the export filter, an MS Excel add-in.
Dose anyone know how to access this filter and its options programmatically?
Specifically i want to choose a resolution level for the exported pic. I am
assuming that such an option exists since there is a facility in a dialogue
box in other MS apps such as Word and Publisher which allows the user to
nominate the resolution of the object that is converted to a jpg or tif etc.
In Publisher, for example, you access this dialogue by => selecting the
object => right click => save as picture => change => and choose a radio
button to select one of four options (web 96dpi, desktop printing 150dpi,
commercial prining 300dpi and original image resolution as specified).
I would like to change this parameter or property of the MS Office add-in
called export filter. I am assuming this is the avenue for exploration since
there appears to be no property of the excel method in excel.
The entry from the F1 help listing on this method is reproduced as follows:
Export Method
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.
Example
This example exports chart one as a GIF file.
Worksheets("Sheet1").ChartObjects(1) _
..Chart.Export _
FileName:="current_sales.gif", FilterName:="GIF"
I am hoping someone will be able to help me.
thanks