Compressing Photos usng VBA

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
--
Gary's Student


"Paul Johnson" wrote:

> 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

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???


"Gary''s Student" wrote:

> 1. open powerpoint (under vba)
> 2. copy the picture and paste into powerpoint
> 3. in powerpoint, save as jpeg
> --
> Gary's Student
>
>
> "Paul Johnson" wrote:
>
> > 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