Changing the DPI in an Excel Picture using VBA

[comconrk]

To decrease the size of a very large worksheet, I would like to decrease the DPI of pictures using VBA. These pictures are just B&W line drawings.

What is a good way to do that?

Thanks very much

 

[GlennUK]

Where are these pictures coming from? I always tweak any such pictures in Paint Shop Pro or other such graphics software before embedding into a worksheet in order to keep the size down.

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[macropod]

Hi comconrk,

AFAIK, there's no way to change the resolution of an embedded object. You could perhaps get around that by saving the worksheet as a web page, then replacing the images.

Doing this programmatically might be difficult as I'm not sure there's any particular relationship between the file names assigned when an Excel worksheet is saved as a web page and the arrangement of the images in the original worksheet. I suspect any arrangement will be based on either the order in which the objects were inserted or the cell addresses selectd at insertion time.

Cheers

[MS MVP - Word]