VBA to password protect a zipped folder using windows compression 2

[knifey]

Hi,
I have some VBA code that zips various folders using the windows built-in compression tool (not winzip) before attaching these zips to emails.
My problem is that I cannot find how to password protect the zipped folder using code.
I found this link on the net that shows my how to do it manually. This is exactly what I need, but how do I achieve this using VBA?:

http://forums.techarena.in/tips-tweaks/1142813.htm

Can anyone point me in the right direction?
Thanks,
Roy
P.S. This is actually a workaround as I cannot find a way to password protect .snp files for emailing. But if anyone knows a way this can be done that would be even better.

 

[lameid]

Two thoughts...

Research the Windows API for Zipping files and use it to program the compression.

Use a zip program that supports zipping with a password from the command line. Use this in conjunction with the shell function to execute it in Access. 7-zip is a popular free zip software that supports a command line. I would assume it supports passwords via command line.

 

[alvechurchdata]

I would assume it supports passwords via command line.

7zip Help says:

7z x archive.zip -psecret

extracts all files from archive.zip using password "secret".

Geoff Franklin

http://www.alvechurchdata.co.uk