Saving a chart as a JPG file

  • Thread starter Thread starter Al
  • Start date Start date
A

Al

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PowerPoint High Resolution Images from PowerPoint 0
Problem exporting Chart as a jpg 4
chart to email 3
Export Chart as TIFF or JPG 8
Why do charts disappear? 2
export chart as wmf 1
How can I save charts as a jpg or gif automatically. 1
save picture in a worksheet programmatically 4

Back
Top