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,

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" wrote:

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,

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

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

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