LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Unzip all encrypted files in a folder with known passwords

Sorry to hijack this thread, however is there any information on the command
line option / switch for creating a self extracting archive (.exe) ?

Regards,
David


"Ron de Bruin" wrote:

I have it also on one of my pages

I have a link to this parameters page
http://www.rondebruin.nl/parameters.htm

Time to update this stuff and add examples for 7zip(great program)

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Dave Peterson" wrote in message ...
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
zip/unzip excel files SHANTA MENON Excel Discussion (Misc queries) 3 July 30th 08 10:10 PM
Unzip specific files with .Namespace? Tom D Excel Programming 8 July 24th 08 11:53 AM
unzip/zip xlsx files burrowsUW Excel Discussion (Misc queries) 3 March 11th 07 06:50 PM
Want to Unzip files automatically Hari[_3_] Excel Programming 1 January 14th 05 03:37 PM
Batch files auto unzip Jonathan Jones Excel Programming 3 October 16th 04 02:15 PM


All times are GMT +1. The time now is 10:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"