Thanks. How do I use "Active Chart Export" from within Excel. In regards to
your program, how do I install it for use. I ran it and it stated that it
wasn't "signed" and therefore I needed to modify security.

"Andy Pope" wrote:

Hi,

You can make use of the charts .Export method.

ActiveChart.Export _
FileName:="MyChart.gif", FilterName:="GIF"

This may interest you if you want to export to image files regularly
http://www.andypope.info/vba/gex.htm

Cheers
Andy

Scott wrote:
Can you save a chart as a picture? I know that I can copy the chart by
"shift", "edit" "copy", and then paste it in another document, but can I save
it as a picture.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info