View Single Post
  #1   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 2007b2

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"