| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to save pictures in excel as gif or jpg
Hi Sven,
Take a look at the code in my addin as a way around the problem. (http://www.andypope.info/vba/gex.htm) Sven Aeyels wrote: 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. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you export pictures from my pictures file into a word docu | New Users to Excel | |||
| Storing Clip Art pictures in My Pictures folder | Excel Discussion (Misc queries) | |||
| Pictures in Excel | Excel Discussion (Misc queries) | |||
| Excel's Compress Pictures or deleting pictures doesn't seem work | Excel Discussion (Misc queries) | |||
| I can't see pictures attached in my mail, I have to save than see | Excel Discussion (Misc queries) | |||
Linear Mode
