Saving a chart as a picture.

[Malcolm Holmes]

I'm sure it's a function which I have used before, but I just can't remember
the route I followed. Any help gratefully received. I'm using Excel 2000.

 

[Don Guillett]

try these

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