Reduce picture file size, KB's, with VBA

  • Thread starter Thread starter Paul B
  • Start date Start date
P

Paul B

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,
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
 
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
 
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
 
Back
Top