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" 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,
>
>

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


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