Compressing Photos usng VBA

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
1. open powerpoint (under vba)
2. copy the picture and paste into powerpoint
3. in powerpoint, save as jpeg
 
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
Excel - Compress Images with VBA 1
Powerpoint does not save photos 2
How to compress interstitial spaces? 6
compress pictures using vba 1
Compress Picture in MS Office 2007 PowerPoint 1
how do I compress photos? 5

Back
Top