Export Chart as GIF on Macintosh OS X

[tcdunn]

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 work
fine, just as a check...

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

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

 

[JE McGimpsey]

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.

 

[tcdunn]

Thanks for the info and workaround. Much better than my other
alternative... manual screen shots with [cmd][shitf][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.