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

"C:\\Program Files\\QuickResizerAPI\\QuickResizerApiExe.exe" 3 "C:\\Documents and Settings\\1 1\\Desktop" "" "c:\\" "" "JPG" "JPG" "hh" -1 600 450 1

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

Shell "C:\jpegsize.exe", vbMaximizedFocus

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.