Vba code to create zip file

**mangeshp4** · 07-15-2011, 01:11 AM

Hello,

Am searching for a vba code which will create a zip file on saving / closing of existing workbook.

Thanks

**royUK** · 07-15-2011, 01:25 AM

What zip software are you using?

**mangeshp4** · 07-15-2011, 01:30 AM

winzip 9.0

**mangeshp4** · 07-18-2011, 02:26 AM

Oops seems my problem is forgotten

**royUK** · 07-18-2011, 05:12 AM

Some sample code here

**snb** · 07-18-2011, 06:35 AM

For this purpose I use Izarcc:

To zip all files in "E:\OF\0_payroll\" into the zipfile "E:\docs_00.zip"

Please Login or Register  to view this content.

Re: Vba code to create zip file