Hi All,

I am trying to let the user open a zipped Excel file (using Winzip)
from Excel, without any success.

Excel itself won't let you drill down into a zipped folder to extract
a file, so am not very hopeful that this can be accomplished through
VBA. Any suggestions?

Thanks!

Hi

One way

You can use shell to unzip the zip file if you find them
You need this Add-in
http://www.winzip.com/wzcline.htm

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

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



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


"il_magpie" wrote in message m...
Hi All,

I am trying to let the user open a zipped Excel file (using Winzip)
from Excel, without any success.

Excel itself won't let you drill down into a zipped folder to extract
a file, so am not very hopeful that this can be accomplished through
VBA. Any suggestions?

Thanks!