Opening zipped *.xls from Excel
 

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!

Opening zipped *.xls from Excel
 

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!