exporting and winzip

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Exporting and Winzip

Exporting and Winzip

resolvedResolved · Low Priority · Version 2007

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

RE: Exporting and Winzip

Thanks Anthony!

I will try to get this working over the next week or so.

Best wishes,

Anna

 

Training courses

 

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Access tip:

Display current date & time in column of any width

The worksheet function =NOW() returns the current date & time. When entered into a column which is not wide enough to display the value NOW returns, the cell displays ###

View all Access hints and tips


Server loaded in 0.06 secs.