I'm writing a automated application that appends data into tables, opens workbooks in Excel and automatically refreshes them.

Now, I've been manually zipping these workbooks and I would like to automatically zip these workbooks into a newly created zip file (I use the date as the file name).

Has anybody been able to manipulate WinZip with VB6 and if so, does anybody know where there are some examples out on the net?

Thank you in advance for any and all help...