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
"Dave Peterson" wrote:
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.)
Matilda wrote:
Hi Dave,
This is the code I am using. http://www.rondebruin.nl/unzip.htm
I can't see an opportunity for passing the password as a parameter here -
which isn't to say it isn't there!
M
"Dave Peterson" wrote:
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.
Matilda wrote:
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
--
Dave Peterson
--
Dave Peterson