Image Control problem

[rags]

Hi

In my application, I'm using Excel worksheet to send Pictures

For Picture , i'm using Image Control
When I 'm loading Image in Image control the size of excel file is growing 20 times larger than image file size.... Is there any way to compress or to control the file size

Rag

 

[Nick Hodge]

Rags

Not that I am aware of. As Excel is not really an 'image' program, I guess
the developers were not too focussed on how big the file became when adding
them. There are several other things like this that bloat XL files beyond
the level of the object.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

Hi

In my application, I'm using Excel worksheet to send Pictures

For Picture , i'm using Image Control.
When I 'm loading Image in Image control the size of excel file is growing

20 times larger than image file size.... Is there any way to compress or to
control the file size.

 

[Jake Marx]

Hi Rags,

As Nick noted, I don't think there's any way to make the file smaller
besides ditching the Image Control. I'm guessing that control stores the
picture as a BMP or similar "compressionless" file type. So if you're
setting the Picture property to a JPG or other compressed type of image
file, the resulting Excel workbook will grow by *much* more than the size of
the JPG file.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]

 

[www.canhelpyou.com]

You may want to change your approach to storing a link to
the picture in the excel file and not the picture itself.
Just a thought. Excel is great spreadsheet but a lousy
photo album.

Regards,

Kent

-----Original Message-----
Hi

In my application, I'm using Excel worksheet to send Pictures

For Picture , i'm using Image Control.
When I 'm loading Image in Image control the size of

excel file is growing 20 times larger than image file
size.... Is there any way to compress or to control the
file size.