Program to ZIp and Unzip files.

**swingy** · 2012-06-26 06:51

Hi,
EDited again for clarity:
------------------------------------------
I am looking for a macro which could help me in putting passwords to different file types ( .doc,.xls,.ppt,.pdf,.xml etc) and zipping them using my existing winzip ver 9. These files are on my c drive and in various folders. I searched for solutions and most of them are specific to a file type but not multiple files.
--------------------------------------------------------------------------

I am looking for a solution which would help me to zip and password protect certain files (.doc,.xls,.ppt,.pdf,.xml etc) on my hard disk (C:\ drive).
These files could be in any folder within c:\. - A way in which, I run a VB script and it in turns puts a defined password in all of the above documents which it is able to find in the c drive, and zips it. Is it possible, appreciate any help on this. I use winzip ver 9.

Thanks

**Xircal** · 2012-06-26 08:45

Open source wise, you can use 7zip: http://www.7-zip.org/

WinRAR is better, but not free: http://www.rarlab.com/

**swingy** · 2012-06-26 10:22

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.

**Browni** · 2012-06-26 10:23

I would seriously recommend that you do not apply a vbscript against the root drive in the way you describe.

A quick scan of my Windows 7 installation shows around 3000 .xml files (none of which I've created) and removing them will break the operating system (that is, if Windows allows me to)

**Xircal** · 2012-06-26 10:47

Originally Posted by swingy

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.

Have a look at this Wiki article: http://www.wikihow.com/Use-7Zip-to-C...ders-in-One-Go

**macropod** · 2012-06-26 22:03

Originally Posted by swingy

I am looking for a macro which could help me in putting passwords to different file types ( .doc,.xls,.ppt,.pdf,.xml etc) and zipping them using my existing winzip ver 9. These files are on my c drive and in various folders. I searched for solutions and most of them are specific to a file type but not multiple files.

If you want to password protect the files before archiving them, you'll need to use their parent applications. You could, instead, encrypt the zip archive.
As for using Winzip 9, AFAIK you can't automate that, as it has no command line interface or vba object model.

**swingy** · 2012-06-27 01:52

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.

**macropod** · 2012-06-27 02:28

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.

**swingy** · 2012-06-27 03:14

Originally Posted by macropod

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

**macropod** · 2012-06-27 03:31

Set of files which we work on need to be password protected for data safety before closing for the day

and

the threat is not of data leakage but of data sharing amongst people

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

If a user's files need to be protected in their absence, keep them in a secure folder that others don't have access to (even when the user is present). This is basic system security and requires a whole lot less 'management' than the approach you're trying to implement. Consider too, what happends when the person 'owning' this process falls under the proverbial bus.

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.

**swingy** · 2012-06-27 04:20

Originally Posted by macropod

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

**macropod** · 2012-06-27 04:31

Originally Posted by swingy

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.

Each user should have their own password-protected user account. If you do that, then the only files that everyone can access are those that are put into public folders. The 'My Documents' folder and everything below it for each user is hidden from every other user - only people with Administrator privileges can access the 'My Documents' folders of other users.

This is all basic system configuration has nothing to do with macros or anything of the kind.

**swingy** · 2012-06-28 02:22

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.

**macropod** · 2012-06-28 02:36

It is ridiculous for any organisation to have an IT policy that doesn't allocate enough space for those who need it and expects files that won't fit within the quota to be stored on the C drive where: (a) they probably don't get backed up; and (b) anyone with access to the PC can access them; but (c) others in the same workgroup cannot (without further workarounds).

This is a serious management issue and your IT department needs to be told by senior management to fix it. The only requirement "to change the IT policy accross all departments and all locations" is that the IT department learns that it is there to serve the users' needs, not to place artificial restrictions on users that could seriously compromise corporate goals. FWIW, before I retired I worked in an organisation where my own IT quota far exceeded the normal allocations as a business case for it existed.

**swingy** · 2012-06-28 03:30

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.

Thread: Program to ZIp and Unzip files.

Thread Tools