How to Extract .zip files stored in a folder using VBA

**zaska** · 07-16-2012, 05:46 AM

Hi all,

Could anyone kindly help me with a VBA code which could extract all the .zip files stored in a local folder say D:\test and then delete the .zip files after extracting? I have the following files in the folder.

cm20SEP2010bhav.csv.zip
fo18SEP2009bhav.csv.zip
eq180909_csv.zip
SCBSEALL1809.zip

Regards,

Zaska

**Kyle123** · 07-16-2012, 06:24 AM

One Way:

Please Login or Register  to view this content.

**zaska** · 07-16-2012, 12:38 PM

Thank you very much ..This code saved me lot of time.

**Cutter** · 07-16-2012, 01:24 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save