Exporting and Winzip

Hi Anna, thanks for your query. You're in luck, someone has already written the code for this:

http://conradsharry.blogspot.co.uk/2007/05/zip-file-using-access-vba-and-winzip.html

This uses the Shell command to launch an application from within VBA and a couple of command line parameters. You'll need to loop through the filenames you want to zip and add them to the archive. Have a look here if you encounter any error:

http://stackoverflow.com/questions/1940626/vba-zip-file-error

...particularly the use of the SLEEP command.

Hope this helps,

Anthony