WinZip

  • Thread starter Thread starter Paul
  • Start date Start date
P

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
 
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
 
Paul said:
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
Click to expand...

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
 
Back
Top