I do not believe that Windows itself has the capability to compress with a password automatically. Someone please correct me if I am incorrect in that.
A couple of options:
Windows can add a password to an encrypted file:
http://techblissonline.com/how-to-password-protect-zip-files-in-windows-xpwindows-vista/
Code could be used to select the keys to do that.
7zip could be used in a command line to encrypt with a password.
________________________________
From: ExcelVBA@yahoogroups.com [ExcelVBA@yahoogroups.com] on behalf of Saurabh Kushwaha [saurabh.rdb@gmail.com]
Sent: Monday, July 22, 2013 9:18 AM
To: ExcelVBA@yahoogroups.com
Cc: ExcelVBA@yahoogroups.com
Subject: Re: [ExcelVBA] Password protecting a file (PDF, CSV, etc)
Hi, I am not able to figure out a way to password protect a zip file. Can you share any link or vba code for that? I think that's the last step required. Thanks!
Sent from my iPhone
On 22-Jul-2013, at 16:35, "Gary D. Schwartz" <gary.schwartz@pobox.com<mailto:gary.schwartz%40pobox.com>> wrote:
> Yes and no.
>
> I had tried it on a work related Excel spreadsheet that a predecessor
> had locked with a password and without documentation.
>
> For short passwords 3-4 characters, the freebie versions of those
> will work. For longer "strong" passwords, not even the paid versions
> work on all files. But overall, you are right; the password will not
> keep out someone determined.
>
> The various ZIP plus password programs use far more secure encryption.
>
> Gary
>
> At 04:57 AM 7/21/2013, Derek Turner wrote:
> >Dear Saurabh
> >
> >Judging from the number of sites offering free Word, Excel and PDF
> >password removers, I would say that for anyone determined to break
> >into your files that passwords are only a minor irritation.
> >
> >Regards
> >
> >Derek Turner ++
> >
>
> --------------------------------------------------------
> Gary D. Schwartz Please reply to: gary.schwartz@pobox.com<mailto:gary.schwartz%40pobox.com>
>
>
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (12) |
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar