WinZip

[Paul]

can i open a winzip file and extract a xl file using vba?
Say i have a file called 1058 and it is filed in a winzip
file called 1000,siilarly i could have a file called 6278
filed in a zip file called 6200.I find that if i use
Application.Findfile I can see the winzip files but cant
open em

 

[Ron de Bruin]

Hi Paul

You can use shell to unzip the zip file if you find them

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

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

 

[Ron de Bruin]

I forgot this
You need this Add-on

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

 

[Keith Willshaw]

can i open a winzip file and extract a xl file using vba?
Say i have a file called 1058 and it is filed in a winzip
file called 1000,siilarly i could have a file called 6278
filed in a zip file called 6200.I find that if i use
Application.Findfile I can see the winzip files but cant
open em

As others have said you can use shell with either PKzip
or Winzip. Alternatively you can use the Zlib dll available
from http://www.gzip.org/zlib/

or the vb code in unz550dN.zip at

http://www.mirror.ac.uk/sites/ftp.info-zip.org/pub/infozip/WIN32/

Keith