Zipping a file

L

Luke Bailey

Hello,
I want to have some code written that will zip down a file, then copy the
file from one directory to another. I already have code for copying the
file, but no clue on how to zip a file down. Any ideas?

Thanks in advance for any thoughts!
 
A

Alt255

I use the WZZIP.EXE command line version of Winzip.
Google WZZIP.EXE and VBA to give examples how this can be done.
 
Top