Try this for unzip test.zip from C:\ to C:\

Sub test()
Shell "c:\program files\winzip\wzunzip c:\test.zip c:\"
End Sub


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Keith" wrote in message ...
I downloaded the WinZip command line add-on from the WinZip website. I
have a macro in EXCEL 97 that downloads a file and when the file is
downloaded, it opens as a zip file.

Two things that I ask:

1. Do I need to do anything in my VBA window to activate the add-on?

2. How can I extract the file (with code) that is inside the zip
window? In looking at other posts I've seen something like...
Shell("C:\whatever path\WZUNZIP.exe bla bla bla")
I put bla bla bla because I have no idea what any of the stuff
following the .exe path means in those posts.

Any ideas? Thanks.