Saving a chart as a picture.

M

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.
 
D

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
 
Top