Macro to zip documents
Posted by Pierre on August 27, 2001 9:29 PM
Is is possible to zip document using a VBA excel macro?
I mean, I am currently performing many times these 2 operations daily
1. using the command of the type ActiveWorkbook.SaveAs FileFormat:=xlnormal etc (my Macro generates about 20 different files)
2. saving MANUALLY all the files with WINZIP.
I would like to do operation 2 programatically, so insert a code that call winzip and ask it to save the ActiveWorkbook.