D DJ Member Dec 28, 2011 #1 Is there any method we can zip all the excel files separately (files are saved in a particular folder) using VBA?
Is there any method we can zip all the excel files separately (files are saved in a particular folder) using VBA?
SirJB7 Excel Rōnin Dec 28, 2011 #2 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!
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!
