Export Chart as GIF on Macintosh OS X

I get an error message trying to export a chart on a Mac running OS X,
Excel version "X for Mac, Service Release 1" from the following code:

Sub ExportChart()
MsgBox (ActiveSheet.ChartObjects(1).Chart.Name)
ActiveSheet.ChartObjects(1).Chart.Export FileName:="mychart.gif",
FilterName:="GIF"
End Sub

... I've never had issues on a PC...and the first MsgBox line works
fine, just as a check...

I get:
"Application Error '1004'"...

Thanks in advance, this is very frustrating...
Tim


---
Message posted from http://www.ExcelForum.com/

In article ,
tcdunn wrote:

I get an error message trying to export a chart on a Mac running OS X,
Excel version "X for Mac, Service Release 1" from the following code:

Sub ExportChart()
MsgBox (ActiveSheet.ChartObjects(1).Chart.Name)
ActiveSheet.ChartObjects(1).Chart.Export FileName:="mychart.gif",
FilterName:="GIF"
End Sub

.. I've never had issues on a PC...and the first MsgBox line works
fine, just as a check...

I get:
"Application Error '1004'"...

This is a known bug in XLv.X. As a workaround you can save the
activesheet as a web page. Charts will be saved as .gifs in the folder
associated with the html document.

Please send MacBU feedback saying you want this fixed ASAP via the
Help/Feedback on Excel menu item in XL's menu bar.

Thanks for the info and workaround. Much better than my other
alternative... manual screen shots with [cmd][****f][3]...

will send the feedback ...

Thanks,
Tim



This is a known bug in XLv.X. As a workaround you can save the
activesheet as a web page. Charts will be saved as .gifs in the folder
associated with the html document.

Please send MacBU feedback saying you want this fixed ASAP via the
Help/Feedback on Excel menu item in XL's menu bar.


---
Message posted from http://www.ExcelForum.com/