View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sven Aeyels Sven Aeyels is offline
external usenet poster
 
Posts: 2
Default how to save pictures in excel as gif or jpg

Hi,

I can save charts to gif. Is it possible to save picture to gif or jpg? I
use the following code to save charts:

Dim mychart As Chart
Set mychart = ActiveSheet.ChartObjects(1).Chart
mychart.Export Filename:=ThisWorkbook.Path & "\chrt1.gif",
FilterName:="GIF"
Set mychart = ActiveSheet.ChartObjects(2).Chart
mychart.Export Filename:=ThisWorkbook.Path & "\chrt2.gif",
FilterName:="GIF"

What do I have to change, so I can save pictures
Thanks in advance.

Kind regards,
Sven.