Anna has attended:
Access Intermediate course
Access VBA course
Finance for Non-Financial Managers course
Exporting and Winzip
FAO: Anthony Malone
As discussed in the training session, what would be the best way to export multiple tables to .txt and also zip them up?!
Thanks
Anna
RE: 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
