How to zip excel files using VBA?

[DJ]

Is there any method we can zip all the excel files separately (files are saved in a particular folder) using VBA?

 

[SirJB7]

Hi, DJ!

Winzip has a command line add-on called Winzip Cline, it's free, you download and install it in the same Winzip folder, and you have access to a lot of parameters to pass from command line. Just use Shell and run it as an external program.

Regards!

 

[JP]

Here is the code I use:


http://www.rondebruin.nl/windowsxpzip.htm