Reduce picture file size, KB's, with VBA

Hi Paul,

In Excel 2003, there's a Compress Picture button on the Pictures toolbar.
Only trouble is, MS forgot to implement the VBA side of this feature.
AFAIK the only way to automate it is with Sendkeys.


Regards,
Vic Eldridge



"Paul B" wrote:

> I don't think this can be done but I thought I would ask an make sure, when
> you import a picture in excel the file size gets huge, you have to size the
> file first in a photo program to reduce the size, in KB, and then bring it
> into excel, just wanting to make sure that there is no way to reduce the
> file using VBA, original file 825KB down to say 35KB.
> Thanks
> Paul B
>
>
> --
> Paul B
> Using Excel 2002 & 2003
>
>
>

Vic, I will have a look at that, using a machine with 2002 right now

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Vic Eldridge" <VicEldridge@discussions.microsoft.com> wrote in message
news:6D0D80C6-A73C-4509-9A09-F628CBF84A07@microsoft.com...
> Hi Paul,
>
> In Excel 2003, there's a Compress Picture button on the Pictures toolbar.
> Only trouble is, MS forgot to implement the VBA side of this feature.
> AFAIK the only way to automate it is with Sendkeys.
>
>
> Regards,
> Vic Eldridge
>
>
>
> "Paul B" wrote:
>
> > I don't think this can be done but I thought I would ask an make sure,
when
> > you import a picture in excel the file size gets huge, you have to size
the
> > file first in a photo program to reduce the size, in KB, and then bring
it
> > into excel, just wanting to make sure that there is no way to reduce the
> > file using VBA, original file 825KB down to say 35KB.
> > Thanks
> > Paul B
> >
> >
> > --
> > Paul B
> > Using Excel 2002 & 2003
> >
> >
> >