Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Compress picture with macro in Excel

75 views
Skip to first unread message

jo

unread,
Mar 10, 2005, 4:10:13 PM3/10/05
to
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

unread,
Mar 10, 2005, 10:39:05 PM3/10/05
to
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

unread,
Mar 15, 2005, 10:14:33 PM3/15/05
to
Are you serious? I'm not sure what this means if you are?

Vic Eldridge

unread,
Mar 16, 2005, 4:23:04 AM3/16/05
to
> 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

unread,
Mar 23, 2005, 6:05:04 AM3/23/05
to
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?
0 new messages