Unzip all encrypted files in a folder with known passwords

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
 
D

Dave Peterson

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.
 
D

Dave Peterson

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.)
 
M

Matilda

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
 
D

Dave Peterson

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run macro on all files in a specific folder 3
Want to Unzip files automatically 1
Password protect all files in a folder 1
Copy and paste in all closed files in a folder 2
Copy All Workbooks Sheets(2) Formats & Values only from Folder A toFolder B 2
Create a list of all files in a folder 2
VBA loop to create named .csv files for all worksheets and workbooks in a folder 11
Ron de Bruin's code "Copy a range from all files in a folder and subfolders (optional)" ??? 10

Top