Unzipping files using WinZIP in VBA

[Xanadu]

I can't seem to find any code to UNzip a file in VBA. Anyone know how to do this? I also can't find anything on WinZIP commands, not even on their website. Any info would be appreciated.

 

[KeithIT]

Did you search this forum yet?

Try this:
Zip Files in VB

 

[Xanadu]

Yes, and I found 2 posts with detailed code on how to ZIP, but none on how to UNZIP. It's probably the same code but with a different WinZIP command, the posts I found used "-d" and "-a", but neither of them is working for me.

 

[KeithIT]

Check out this site. I found it using the link in the post I linked to above.

http://www.info-zip.org/pub/infozip/UnZip.html#Win32

 

[Xanadu]

Well, I'm first scanning the registry to see what program is associated with a ZIP archive, and then I'm trying to open a file with that program. All I need to do is replicate what happens when the user double-clicks a ZIP archive in Windows Explorer, it can't be THAT difficult. I can do it rather easily with Excel or Word files.

 

[jamsta]

Hi all,

I realise that this is an old thread, but hopefully I can kick it off again. I would like some code that extracts a file from a zip folder, renames and saves to a specified location. I've tried the code posted by Darth Vodka http://www.access-programmers.co.uk/forums/showthread.php?t=144356 but it gets stuck at the point of checking for the existence of Winzip.

Any fresh thoughts on this?

thanks