Exporting charts out as GIF or JPG files

Topic

New Reply

I’m now using Excel 2007 and can’t find how to export a chart to an image file like I could in older versions.

I used to be able to use the code below to do it but it doesn’t work in 2007. Any ideas?

Worksheets(ActiveSheet.Name).ChartObjects(1) _
.Chart.Export _
Filename:=”c:current_sales.gif”, FilterName:=”GIF”

Reply | Quote

Replies

I can’t comment on XL2007 since I don’t use it, but FYI:

Worksheets(ActiveSheet.Name).

can be simplified to just:
ActiveSheet.

Steve

Reply | Quote

Your code works fine for me in 2007. Are you getting an error of some sort?

Reply | Quote

It works for me as well.
However, IF you are using Windows Vista OR Windows 7, you will find that Root of C: is by default a protected Path.

Have you tried changing the Path to somewhere else such as My Documents?

Reply | Quote

I found the answer. I was trying to save the chart from a chart sheet.

THANKS much for your checking!

Reply | Quote