View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Tushar Mehta Tushar Mehta is offline
external usenet poster
 
Posts: 1,071
Default Export chart to GIF no longer works after installing Excel 2007b2

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