Look into a directory for a zip, delete, and repeat until directory is empty.

Hi All,


I have programmed a Module [linked to a button on the worksheet] that has the user manually select a .zip file, and analyzes the contents and subsequently deletes the original zipped file. The user would conduct this exercise until all zip files in one folder are empty.

What I don't know how to do is have it look in that folder as a default for any zip file; and sequentially conduct the module on each, until the folder is empty (it would become empty because the module deletes each one-by-one).

So the ultimate result is by pressing that button, the analysis on all files is done in the background.

Would anyone mind helping? I'm very limited in VB; This is my first project using it :-(.


-MG