Creating a compressed folder

J

James Franklin

Hi,

Can anyone tell me if there is a way of creating a compressed(zipped) folder
from within my VBA code?

I have a document management database which creates/moves/deletes etc files
and folders using the FileSystemObject. A folder may contain several
subfolders, each with files in them.

I would like to be able within Access to create a compressed folder so that
this can be attached to an email which Access creates. This would allow the
email recipient to uncompress the folder back to its original file
structure, as well as having several files contained conveniently in one
attachment.

Any help would be greatly appreciated!

Jim.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top