Hi

I am running Excel XP.

Is there a way to programmatically save each chart on a workbook as a
separate JPG or other graphics file?

Thanks in advance

Hi
see:
http://j-walk.com/ss/excel/files/charttools.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"Al" schrieb im Newsbeitrag
...
Hi

I am running Excel XP.

Is there a way to programmatically save each chart on a workbook as a
separate JPG or other graphics file?

Thanks in advance

these should help.
Sub ExportChartGIF()
ActiveChart.Export Filename:="C:\a\MyChart.gif", _
FilterName:="GIF"
End Sub
Sub ExportChartJPG()
ActiveChart.Export Filename:="C:\a\MyChart.jpg", _
FilterName:="jpeg"
End Sub

--
Don Guillett
SalesAid Software

"Al" wrote in message
...
Hi

I am running Excel XP.

Is there a way to programmatically save each chart on a workbook as a
separate JPG or other graphics file?

Thanks in advance