Re-sizing inserted photos

[ultrawat]

I have a code which inserts photos into a worksheet. The code inserts the image to a fixed size and position.

My problem is that the size of the jpg file is fairly large, so when the worksheet is saved the xls file is large.

Is there any way of adding code which resizes/resamples the jpg image as it is being inserted? A reduction in quality is not a major concern.

Thanks in anticipation

 

[BrianB]

As a quickie ... there is some code at the end of this :-

http://www.mrexcel.com/board2/viewtopic.php?t=145831&highlight=picture

 

[ultrawat]

Thanks for this......

Does this code just re-size the photo...or does it reduce the size of the photo file??

Thanks again for your input

 

[BrianB]

Just done a test to check.

The picture becomes part of the Excel workbook. The.xls file size increases, and hiding the original file has no effect. Excel cannot make changes to picture files on disk.

 

[ultrawat]

Thanks BrianB........worth a try.....