P
Peter
For Excel 2003....
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 (1- web 96dpi, 2- desktop printing
150dpi,
3- commercial prining 300dpi, and 4- original image resolution as specified).
I would like to change this parameter or property of the MS Office add-in
called export filter using VBA code. I am assuming this "export filter" is
the most likely candidate for exploration since there appears to be no such
property of the export graphic 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 with my problem of not knowing
how to alter resolution of the charts that i want to export as image files.
I have many to export and to regularly update and export and so i want a
programmatic non user intervention solution.
Many thanks in advance.
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 (1- web 96dpi, 2- desktop printing
150dpi,
3- commercial prining 300dpi, and 4- original image resolution as specified).
I would like to change this parameter or property of the MS Office add-in
called export filter using VBA code. I am assuming this "export filter" is
the most likely candidate for exploration since there appears to be no such
property of the export graphic 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 with my problem of not knowing
how to alter resolution of the charts that i want to export as image files.
I have many to export and to regularly update and export and so i want a
programmatic non user intervention solution.
Many thanks in advance.