Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
export method filter specific options
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 -- Peter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Limit filter options in Auto Filter | Excel Discussion (Misc queries) | |||
Export options | Excel Programming | |||
filter: how to print filter list options in dropdown box | Excel Discussion (Misc queries) | |||
Setting the Options of the Find method | Excel Programming | |||
export method not working properly | Excel Programming |