Unzip all encrypted files in a folder with known passwords

  • Thread starter Thread starter Matilda
  • Start date Start date
M

Matilda

Dear Gurus,

I found the link to Ron de Bruin's excellent code for unzipping files in
this discussion group and it works brilliantly.

I now have the need to unzip some archived files which were initially
encrypted for email transmission. I have the passwords, and have written the
code up to the point of passing the password. Cannot find reference to this
problem anywhere on the net (wonder why :-)) ) but since my need is strictly
ethical, thought I would post it here.
As things are, I run my code, then sit and tap <ctrl v> <enter> each time
the prompt appears for each file opened. Erk.

Any alternatives?

TIA,


Matilda
 
I'm not sure what code of Ron's you're using, but isn't there an option to
include the password--well, if you're using the winzip commandline version of
the code.
 
If you look at this site:
http://www.memecode.com/docs/winzip.html
(just did a google search for
commandline for winzip password
and it was one of the topmost hits)

This line:
ShellStr = PathWinZip & "Winzip32 -min -e" _

Can be changed to:
ShellStr = PathWinZip & "Winzip32 -min -e -sSecretPassword" _
or if you need to put quotes around the password:
ShellStr = PathWinZip & "Winzip32 -min -e " _
& "-s" & Chr(34) & "SecretPassword" & Chr(34) _

(Untested, uncompiled. You may have to play with the syntax.)
 
Thanks, Dave. I'd have googled it, too, had I understood the term "command
line for winzip password" in a vba context.
Thanks for your help.

M
 
Not a problem.

Ron's program shells out to a command prompt to execute the command.

If you're old enough to remember computers before windows, you may remember
working at a DOS prompt--instead of pointing and clicking or doubleclicking,
you'd actually have to type the command and all the stuff that gets passed to
that command.

That's what the "commandline" stuff means.
Thanks, Dave. I'd have googled it, too, had I understood the term "command
line for winzip password" in a vba context.
Thanks for your help.

M
Click to expand...
 
Back
Top