Replies

Hi Ruirib,
Thanks for the link. Winzip courier is pretty close to what I was looking for. However, we use winzip 9 and it doesn’t have the options which courier provides. Unfortunately, cannot use anything other than winzip 9.
I am searching for a macro which can initiate winzip to zip the attachements within outlook mail itself.

Thanks

Hi Roderunner
Thanks for your response. I can only use winzip 9 and outlook 2003. Looking for an automated compression while using outlook mail. In the normal process, all attachments get attached in their original
state. looking for a macro which use shell commands to execute winzip and attach a zipped content against their normal state.
Thanks

Give them a worse “solution” than the reasonable ones already suggested.

🙂 That was funny ! Come to think of it – It works !

Ok.. So I looked up the net and found out that a certain DOS script can hide and unhide all user created folders. Supply one password to hide and unhide all folders. This actually served my purpose to a great extent. However, one small bit left – are some of those files which get saved in the root and not the folders…

Thanks Paul , I reciprocate your suggestion, but not in a position to do much about it at the moment, even if i would like to. 🙁

eager to look at alternatives / suggestions.

Hi Paul

Our IT policy allows user to save documents in ‘My Document’ folders (which is restricted and user specific) but do not restrict access to over all c drive. Profile space allocated per person is not enough to store this kind of database. Hence, Users save files in other portions of C drive. Your suggestion would require us to change the IT policy accross all departments and all locations. Which unfortunatley, is not a possible solution for us. We (a small department) have the captioned need others outside our department don’t.

and

So how is the sharing of data after office hours any more or less secure than sharing it during office hours?

Ultimately, if you want to go down the vba-driven zip approach, you’re going to have to upgrade to WinZip 12. Hardly a great financial burden.

Hi Paul,
It is difficult to explain the set up here, however, I’ll try – The PC / workstation is used by multiple users 24 /7 . hence, each user will have to access c drive and work on his (respective) folders. before leaving for the day, lock all files he worked on and then unlock them when he resumes his work again. personal password will provide assistance in data not being shared with others who are using the same workstation.

However, you mentioned securing a folder which seems to be a better idea.. let me know if this is possible through a macro. User can protect his selective folders ( 25 – 30 per user) through a macro and unprotect them when he wishes to use files under those folders.

If the above is possible, then we can avoid the need for zipping the files altogether and simply password protect folders instead.

Thank you for your patience.

Regards

Is there a reason the security features of Windows itself aren’t sufficient?

If your files need password protection, there is no point in having a system-wide password for them. It rather defeats the purpose, since the compromising af a single password compromises the security of all your files. Accordingly, you’d need individual passwords for all files, or at least defined groups of files. And, if you put those passwords into a macro, all one needs to compromise your security is to gain access to the file containing the macro. It is very easy to bypass vba project passwords.

Sure windows security features / firewalls etc all are in place and working.. However, this one is an additional control at user’s end. An internal quality requirement. One password would be good enough as the threat is not of data leakage but of data sharing amongst people.
Thanks

Thank you all for your responses.

Could any of you help me by suggesting a better alternative to achieve what i am looking for?

Requirement – Set of files which we work on need to be password protected for data safety before closing for the day. These files are of various types but in selected folders (not all folders). Next day we need to start using the same files opening them/ updating them, closing them multiple times.
I was looking for a macro which would help me do a ‘mass protect’ than having to protect them individually and then unprotect them the next day when we are required to work on them. The number of files are high and protecting them and again unprotecting them takes a lot of time.

If the above cannont be achieved through a macro , then I would really appreciate any suggestion / alternatives.

Thanks again.

PS : Xircal, checked the article on 7 zip, unfortunately, can’t use open source / other softwares.

Xircal
I read my post again and realised that I have made a mess of it. Sorry about that.
Allow me to clarify : I already have winzip ver. 9, But I need a macro which would help me in zipping files and putting a password protection . These files could be in different folders, and zipping and putting password is a time consuming activity. I am looking for a macro which can help me achieve this. There are mulitple files in multiple folders which is why i am looking for ways to automate this.
for a reading ease – i am editing my first post again
Thanks.

Hi Zeddy ,

thanks a lot for this amazing solution !!! works like a charm ! it is a learning for me .. Thank You ..thank you thank you ! 😀