Compressing Photos usng VBA

G

Guest

Excel XP and 2003 provide the user with the ability to compress photos
inserted into an Excel document!

Is there a way to Compress photos in Excel 2003 using VBA?

I've searched but no luck....

Any help is greatly appreciated
 
G

Guest

1. open powerpoint (under vba)
2. copy the picture and paste into powerpoint
3. in powerpoint, save as jpeg
 
G

Guest

I was hoping to find the appropriate method for the "ShapeRange" object

"Selection.shaperange.compress"

When making other formatting changes to a picture, I've used this object
reference, however I can't find method for compressing the photo.

Not sure where to go from here???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Compress Pictures using VBA 2
VBA to compress photos in an excel worksheets 2
Powerpoint does not save photos 2
Excel - Compress Images with VBA 1
VBA to create directories based on 'date picture taken' 2
How to compress interstitial spaces? 6
VBA to create dir's based on 'date picture taken' 1
In VBA, check if file is corrupt or not Excel 5

Top