View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Paul B Paul B is offline
external usenet poster
 
Posts: 709
Default Reduce picture file size, KB's, with VBA

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" wrote in message
...
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