Thread: unzipping files
View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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!