Image file resize

**D_Rennie** · 09-09-2009, 12:45 PM

Hello im sending image files via EMail attachment with VBA code.

Though the images are 5Mb+ each and when sending 20+ on a 128k upload connection that takes a while.

Is there a way that the images can be resized through vba and saved as a new folder.
Or send the images to another program and pause the code until the resizing has been done.

Thankyou.

Just found this http://www.lebans.com/imageclass.htm for axcess VBA so im guessing that i can be done.
Im looking to do a batch of files.
any advice would help

**D_Rennie** · 09-09-2009, 11:11 PM

i also found http://www.rw-designer.com/picture-resize at it allows for running in command line.
Though i realy dont know whats going on.
can this be done??

also found http://www.download32.com/quickresizerapi-d18881.html i have got this to work in command prompt though is there a way to send

Please Login or Register  to view this content.

through to the command prompt
ive tryed call shell though vba didnt like the above code

cheers

**D_Rennie** · 09-10-2009, 02:29 AM

after a lot of searching ive came accross a command line image resizer http://www.bestcode.com/html/jpegsize.html with this i can work it into my code quite easly.

**D_Rennie** · 09-10-2009, 05:01 AM

just in case anyone everlooks up this thread. Ill post everythink to finish it off.

call the program like

Please Login or Register  to view this content.

Though im ny case i needed vba to wait until all the images where resized.
http://www.appspro.com/Tips/VBA%20Tips.htm has a great shell and wait example for doing just this.