Saving a chart as a picture.

  • Thread starter Thread starter Malcolm Holmes
  • Start date Start date
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.
 
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
 
Back
Top