unzipping files

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!

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" <GEORGIA@discussions.microsoft.com> wrote in message
news:97A9706A-8734-4A79-936F-77EE50CDA8CF@microsoft.com...
> 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!
>

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" <GEORGIA@discussions.microsoft.com> wrote in message
> news:97A9706A-8734-4A79-936F-77EE50CDA8CF@microsoft.com...
> > 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!
> >
>
>
>

The information page on the command line addon
http://www.winzip.com/prodpagecl.htm

says:

Fully Documented All commands and options are documented in a Windows help
file for ease of reference.

I assume if you are using the addon, you have the help file.

--
Regards,
Tom Ogilvy


"GEORGIA" <GEORGIA@discussions.microsoft.com> wrote in message
news:44F73EA6-CFA8-4562-B99E-C886BF7AFF0D@microsoft.com...
> 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" <GEORGIA@discussions.microsoft.com> wrote in message
> > news:97A9706A-8734-4A79-936F-77EE50CDA8CF@microsoft.com...
> > > 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!
> > >
> >
> >
> >

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" <GEORGIA@discussions.microsoft.com> wrote in message
news:44F73EA6-CFA8-4562-B99E-C886BF7AFF0D@microsoft.com...
> 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" <GEORGIA@discussions.microsoft.com> wrote in message
> > news:97A9706A-8734-4A79-936F-77EE50CDA8CF@microsoft.com...
> > > 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!
> > >
> >
> >
> >

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" <twogilvy@msn.com> wrote in message
news:uiAssXemFHA.1968@TK2MSFTNGP14.phx.gbl...
> 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" <GEORGIA@discussions.microsoft.com> wrote in message
> news:44F73EA6-CFA8-4562-B99E-C886BF7AFF0D@microsoft.com...
> > 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" <GEORGIA@discussions.microsoft.com> wrote in message
> > > news:97A9706A-8734-4A79-936F-77EE50CDA8CF@microsoft.com...
> > > > 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!
> > > >
> > >
> > >
> > >
>
>

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" <twogilvy@msn.com> wrote in message news:uukLz5emFHA.3916@TK2MSFTNGP10.phx.gbl...
> 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" <twogilvy@msn.com> wrote in message
> news:uiAssXemFHA.1968@TK2MSFTNGP14.phx.gbl...
>> 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" <GEORGIA@discussions.microsoft.com> wrote in message
>> news:44F73EA6-CFA8-4562-B99E-C886BF7AFF0D@microsoft.com...
>> > 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" <GEORGIA@discussions.microsoft.com> wrote in message
>> > > news:97A9706A-8734-4A79-936F-77EE50CDA8CF@microsoft.com...
>> > > > 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!
>> > > >
>> > >
>> > >
>> > >
>>
>>
>
>

Why not document the arguments on your page.

--
Regards,
Tom Ogilvy


"Ron de Bruin" <rondebruin@kabelfoon.nl> wrote in message
news:OK1tcFnmFHA.3568@TK2MSFTNGP10.phx.gbl...
> 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" <twogilvy@msn.com> wrote in message
news:uukLz5emFHA.3916@TK2MSFTNGP10.phx.gbl...
> > 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" <twogilvy@msn.com> wrote in message
> > news:uiAssXemFHA.1968@TK2MSFTNGP14.phx.gbl...
> >> 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" <GEORGIA@discussions.microsoft.com> wrote in message
> >> news:44F73EA6-CFA8-4562-B99E-C886BF7AFF0D@microsoft.com...
> >> > 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" <GEORGIA@discussions.microsoft.com> wrote in message
> >> > > news:97A9706A-8734-4A79-936F-77EE50CDA8CF@microsoft.com...
> >> > > > 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!
> >> > > >
> >> > >
> >> > >
> >> > >
> >>
> >>
> >
> >
>
>

To the OP:

I was using a different help file and assuming the arguments would be the
same - apparently not:



http://www.memecode.com/docs/winzip.html

--
Regards,
Tom Ogilvy

"Tom Ogilvy" <twogilvy@msn.com> wrote in message
news:uukLz5emFHA.3916@TK2MSFTNGP10.phx.gbl...
> 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" <twogilvy@msn.com> wrote in message
> news:uiAssXemFHA.1968@TK2MSFTNGP14.phx.gbl...
> > 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" <GEORGIA@discussions.microsoft.com> wrote in message
> > news:44F73EA6-CFA8-4562-B99E-C886BF7AFF0D@microsoft.com...
> > > 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" <GEORGIA@discussions.microsoft.com> wrote in message
> > > > news:97A9706A-8734-4A79-936F-77EE50CDA8CF@microsoft.com...
> > > > > 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!
> > > > >
> > > >
> > > >
> > > >
> >
> >
>
>

Hi Tom

I will add them this week

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Tom Ogilvy" <twogilvy@msn.com> wrote in message news:uZZmH04mFHA.3380@TK2MSFTNGP12.phx.gbl...
> Why not document the arguments on your page.
>
> --
> Regards,
> Tom Ogilvy
>
>
> "Ron de Bruin" <rondebruin@kabelfoon.nl> wrote in message
> news:OK1tcFnmFHA.3568@TK2MSFTNGP10.phx.gbl...
>> 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" <twogilvy@msn.com> wrote in message
> news:uukLz5emFHA.3916@TK2MSFTNGP10.phx.gbl...
>> > 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" <twogilvy@msn.com> wrote in message
>> > news:uiAssXemFHA.1968@TK2MSFTNGP14.phx.gbl...
>> >> 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" <GEORGIA@discussions.microsoft.com> wrote in message
>> >> news:44F73EA6-CFA8-4562-B99E-C886BF7AFF0D@microsoft.com...
>> >> > 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" <GEORGIA@discussions.microsoft.com> wrote in message
>> >> > > news:97A9706A-8734-4A79-936F-77EE50CDA8CF@microsoft.com...
>> >> > > > 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!
>> >> > > >
>> >> > >
>> >> > >
>> >> > >
>> >>
>> >>
>> >
>> >
>>
>>
>
>

Done

http://www.rondebruin.nl/zip.htm
http://www.rondebruin.nl/unzip.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Ron de Bruin" <rondebruin@kabelfoon.nl> wrote in message news:e6J0Rx5mFHA.3336@tk2msftngp13.phx.gbl...
> Hi Tom
>
> I will add them this week
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "Tom Ogilvy" <twogilvy@msn.com> wrote in message news:uZZmH04mFHA.3380@TK2MSFTNGP12.phx.gbl...
>> Why not document the arguments on your page.
>>
>> --
>> Regards,
>> Tom Ogilvy
>>
>>
>> "Ron de Bruin" <rondebruin@kabelfoon.nl> wrote in message
>> news:OK1tcFnmFHA.3568@TK2MSFTNGP10.phx.gbl...
>>> 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" <twogilvy@msn.com> wrote in message
>> news:uukLz5emFHA.3916@TK2MSFTNGP10.phx.gbl...
>>> > 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" <twogilvy@msn.com> wrote in message
>>> > news:uiAssXemFHA.1968@TK2MSFTNGP14.phx.gbl...
>>> >> 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" <GEORGIA@discussions.microsoft.com> wrote in message
>>> >> news:44F73EA6-CFA8-4562-B99E-C886BF7AFF0D@microsoft.com...
>>> >> > 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" <GEORGIA@discussions.microsoft.com> wrote in message
>>> >> > > news:97A9706A-8734-4A79-936F-77EE50CDA8CF@microsoft.com...
>>> >> > > > 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!
>>> >> > > >
>>> >> > >
>>> >> > >
>>> >> > >
>>> >>
>>> >>
>>> >
>>> >
>>>
>>>
>>
>>
>
>