From: Gerald on
Is there a way to have VBA macro compress pictures?

If I use CommandBars.FindControl(Id:=6382).Execute the dialog box pops up.

I want to be able to do the whole compression in the macro without a dialog
box popping up.
Is there any way to do that?

Gerald