Posted to microsoft.public.excel.programming
|
|
unzipping files
Done
http://www.rondebruin.nl/zip.htm
http://www.rondebruin.nl/unzip.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Ron de Bruin" wrote in message ...
Hi Tom
I will add them this week
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Tom Ogilvy" wrote in message ...
Why not document the arguments on your page.
--
Regards,
Tom Ogilvy
"Ron de Bruin" wrote in message
...
Hi
From the Winzip Help
-o and -j stands for "overwrite existing files without prompting" and
"Junk
pathnames", Unless -j is specified,folder information is used
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Tom Ogilvy" wrote in message
...
Actually, while I haven't tested it. I would expect the default to be
to
extract without using the path since there is a -d option to tell it to
extract using the path - but since you say it is using the path, that
may
not be true.
Also, the help is for the commandline addon - I assume the arguments
would
be the same for winzip32 but no guarantee.
--
Regards,
Tom Ogilvy
"Tom Ogilvy" wrote in message
...
ShellStr = PathWinZip & "Winzip32 -min -e -o" _
& " " & Chr(34) & FileNameZip & Chr(34) _
& " " & Chr(34) & FolderName & Chr(34)
should overwrite.
As to the path, I believe you would have to build the archive without
using
the save path option from what I could see.
--
Regards,
Tom Ogilvy
"GEORGIA" wrote in message
...
sorry my ignorance....
how would i go about doing that?
"Tom Ogilvy" wrote:
These would both be a function of the command line arguments you
furnish
to
Winzip. Just identify what the correct arguments are and put them
in
the
command string.
--
Regards,
Tom Ogilvy
"GEORGIA" wrote in message
...
Thanks to Ron's code http://www.rondebruin.nl/zip.htm
i was able to unzip the files.
However, I need little modification and I am new to VB so i am
not
quiet
sure how to do so.
here's part of my code:
FileNameZip = "N:\Customer Counts\CEN.zip"
FolderName = "N:\Customer Counts\Tag"
FolderName = "N:\Customer Counts\Tag"
ShellStr = PathWinZip & "Winzip32 -min -e" _
& " " & Chr(34) & FileNameZip & Chr(34) _
& " " & Chr(34) & FolderName & Chr(34)
ShellAndWait ShellStr, vbHide
although it is extracting it to " Tag" folder, there are
subfolders
listed
so actually, it is extracting it to:
N:\Customer
Counts\Tag\dwstage\homedirs\reporting\scripts\data _spool
how would I delete the other folders? i want the files to extract
to
the
"Tag" folder.
Also, if the file already exist, I want it to overwrite it
automatically.
Thank you!
|