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?


"Vic Eldridge" wrote:

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