Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Decompressing folders using VBA

Status
Not open for further replies.

popper

Programmer
Dec 19, 2002
103
AU
I am aware that there are various codes around in VBA to zip and unzip files in relation to the Winzip utility. However, I need to know how I can write VBA code that will decompress a Windows compressed file/folder. Any help would be greatly appreciated.

Thank you
 
>Windows compressed file/folder

Which style? There's the NTFS compression ('Compress contents to save disk space' option under a file/folders Advanced Attributes) or "Send to Compressed (zipped) Folder" off the right-click menu.

If the latter, then you could still work with winzip - or you can create and manipulate zip files directly from Windows with no 3rd party applications or controls at all. I've illustrated this a few times in the VB5/6 forum. Here's a link to one of my examples (about half way down the thread): thread222-1302498 (should be useable in VBA).

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top