Hi,
I need to unzip a file and extract a excel spreadsheet
from it. Can any one tell me how to do this in VBA or
where I can find the tools to do this

If you use Winzip then you can do this

Check out the Winzip website for this Add-on
http://www.winzip.com/wzcline.htm

Afer you install this you can use something like this

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



"MarkS" wrote in message ...
Hi,
I need to unzip a file and extract a excel spreadsheet
from it. Can any one tell me how to do this in VBA or
where I can find the tools to do this