macro to zip and then password protect folders

[VinodN]

Hi,

I have been able to save a few files in multiple folders through a macro. I am now trying to zip those individual folders and also have to assign individual passwords to these folders. The passwords are to be taken from the database maintained.

Is there a macro available for this.?

Please help!!

Regards,
Vinod

 

[Deepak]

Have u visited here!!

http://www.rondebruin.nl/win/s7/win003.htm

 

[VinodN]

This talks about installing 7 zip and running the macro using 7zip. Can it not be done through winzip which would be commonly available on pcs.?

 

[Deepak]

But this might hot have a password option.!

http://www.rondebruin.nl/win/s7/win001.htm