Home |
Search |
Today's Posts |
#8
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
zip/unzip excel files | Excel Discussion (Misc queries) | |||
Unzip specific files with .Namespace? | Excel Programming | |||
unzip/zip xlsx files | Excel Discussion (Misc queries) | |||
Want to Unzip files automatically | Excel Programming | |||
Batch files auto unzip | Excel Programming |