View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.charting
excelFan excelFan is offline
external usenet poster
 
Posts: 53
Default Export chart to GIF no longer works after installing Excel 200

Jon,
Thank you very much for your insight. It sounds like you're onto something
and I would very much want to give a try at reverting back to the old GIF
filter. However, I must confess, I don't know the location of the shared
folder, nor the name of the gif filter. Can you help?

--
Regards,
Pete

"Jon Peltier" wrote:

I noticed this problem on one of my computers. The filters in the Microsoft
Shared folder are all newer than Office 2003, dated in 2006. Except for the
TIFF filter, which is still dated 2000, and the export to TIFF still works.
I tried to reinstall Office 2003's filters, but apparently it checks the
file date stamp prior to overwriting, and the files didn't change. I didn't
yet try deleting the filters then reinstalling.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"ExcelFan" wrote in message
...
Tushar, thank you for your response.
If the GIF filter was somehow removed by the install of Excel 2007b2, do
you
think reinstalling Excel 2000 would be a reasonable fix?

BTW - I believe you helped me with a charting issue many years ago and I'd
just like to thank you for taking the time to help me and the Excel
community.


"Tushar Mehta" wrote:

In article ,
says...
I've used the following Visual Basic code in Excel 2000 to export a
chart to
GIF. However, after installing Excel 2007b2 I now get errors (method
of
export failed) when using the same old code in Excel 2000 and cannot
export.
Does anybody know if something has changed?

ActiveSheet.ChartObjects(1).Activate
ActiveChart.Export Filename:="C:\Documents and Settings\user\My
Documents\mychart.gif", filtername:="gif"

Maybe, installing 2007 Beta2 removed the filter needed to export as a
GIF?

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions