Zipping a file

[Guest]

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!

 

[Alt255]

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