Compress picture with macro in Excel

[jo]

In Excel 2003 there is a buttom within the format picture dialog to
compress pictures in the document. I would like to automate this step
with a macro. I used the macro recorder when performing this action
and it does not seem to record and information about compression. Is
there a way to compress all pictures in the document with a macro?

Thanks,

 

[Vic Eldridge]

Hi Jo,

It looks like MS forgot to implement the VBA side of this new feature.
Pretty lame hey ?

Best I could do was,
SendKeys "%oi%m%a~~{esc}"


Regards,
Vic Eldridge

 

[jo]

Are you serious? I'm not sure what this means if you are?

 

[Vic Eldridge]

Are you serious? I'm not sure what this means if you are?

Yes Jo, I was being serious.
I would of expected the PictureFormat object to have a Compress method or a
Compressed property. But I don't see one anywhere.

With something the size of MS Office, release dates are determined by the
accountants, not the programmers. I know this won't help much, but try to
remember that even though it's not perfect, it's still the best spreadsheet
available.


Regards,
Vic Eldridge

 

[Ivor]

Have you actually contacted MS to see what their intentions are in this regard.
The inability to select all pictures in a spreadsheet and compress them with
VBA kills the automation of catalogue reports as the time it takes to print a
catalogue with 30+ (jpegs) pix of 2mb is too long to be practical?