Opening zipped *.xls from Excel

[il_magpie]

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!

 

[Ron de Bruin]

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