How can I save a chart in a worksheet as a gif which I can later use in a
web page?

Thanks, CMA

Hi,

You can export the chart via vba code.
Activechart.export "C:\mychart.gif"

Cheers
Andy

cmar wrote:
How can I save a chart in a worksheet as a gif which I can later use in a
web page?

Thanks, CMA



--

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

John Walkenbach's Chart Tools add-in (free at http://j-walk.com) has
this utility built in, so someone needn't dive into VBA to get this
functionality.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Andy Pope wrote:
Hi,

You can export the chart via vba code.
Activechart.export "C:\mychart.gif"

Cheers
Andy

cmar wrote:

How can I save a chart in a worksheet as a gif which I can later use
in a web page?

Thanks, CMA