Reduce picture file size, KB's, with VBA

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

Paul,
When you resize and image and want to then resave it, you have to use a
program that will "resample" the image. A photo is made up of
thousands/millions of pixels. When you see the image as a different
size, then those pixels are different, and in different places. Excel
can't do all that. There is an excellent freeware program that deals
with images, including resizing them. Go to http:\\www.irfanview.com
Hope that helps,
Notawahoo

motawahoo, that's what I thought, I have a program to do that thought that
if it could be done in excel it would just save a step.
Thanks

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

"notawahoo" <notawahoo@yahoo.com> wrote in message
news:1133628591.430932.217600@f14g2000cwb.googlegroups.com...
> Paul,
> When you resize and image and want to then resave it, you have to use a
> program that will "resample" the image. A photo is made up of
> thousands/millions of pixels. When you see the image as a different
> size, then those pixels are different, and in different places. Excel
> can't do all that. There is an excellent freeware program that deals
> with images, including resizing them. Go to http:\\www.irfanview.com
> Hope that helps,
> Notawahoo
>

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