Export Chart as TIF

[stanl]

The .tif filter does not come with Office 2003, nor is it part of the XP OCONVCPK filter pack. However the tiffim32.flt is available, so I placed it in the \grphflt subdir in Program Files and ran the .reg file below (based on the XP 2002 Install), under the assumption that tif behaves like gif and the same .flt can be used for both Import and Export. When trying to export a chart with filter="tif" it fails. I have seen posts that tif is an acceptable format for Excel, so perhaps there is something wrong with the .reg entries. If anyone has TIF as an Chart Export option, perhaps you could post your exported Reg Key for comparison.
TIA
Stan

REGEDIT4
 
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Graphics Filters\Export\TIFF]
"Path"="C:\\PROGRA~1\\COMMON~1\\MICROS~1\\Grphflt\\TIFFim32.FLT"
"Name"="Tag Image File Format"
"Extensions"="tif"
 
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Graphics Filters\Export\TIFF\Options\Filter API]
 
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Graphics Filters\Export\TIFF\Options\Image API]
"Time Stamp"=dword:01be2232
"Compression Type"=dword:00000080
"Black Is 0"="Yes"
"Description"=dword:00000007
"BiLevel"="1, 141, 1"
"GrayScale"="1672, 177, 1"
"Palette"="142, 177, 1"
"RGB"="128, 161, 3"
"RGB Planar"="128, 161, 3"
"Halftones"="No"
 
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Graphics Filters\Export\TIFF\Options]
"ShowProgressDialog"="Yes"
"Quality"=dword:0000004b

[jolivanes]

Hi Stanl
Following works for me (Office 2003)
[VBA]
Sheets("My_Chart").Select
ActiveChart.Export Filename:="D:\My Documents\My Pics\NewChart.tif", _
FilterName:="tif"
[/VBA]
HTH
Good luck
John

[stanl]

Hi Stanl
Following works for me (Office 2003)
[vba]
John

Great. Could you post the exported registry key, so I can compare. Perhaps I also need an entry in the Shared\Dll key???

[stanl]

Got it! DWORD in the shared DLL should be 1 not 2, and since the filter is built into XP no need for the API keys. Sometimes all it takes is for someone to say "HAH HAH! It works for me..."

[jolivanes]

stanl.
Good. Just for interests sake. Do both versions of VB work?
John

[stanl]

stanl.
Good. Just for interests sake. Do both versions of VB work?
John

This had nothing to do with VB or versions. It was about formatting .reg files.
Stan

[xman2000]

Hi Stanl,

you have sucess?
i work in this now, november 2016.

please sample file of filters graphics Office 2007.
thanks!