PDA

View Full Version : Open all Zipped files within folder of the xlsm file.



ChrisAch
11-10-2015, 10:11 AM
Hi All.

Im trying to design a macro, that opens all zip files in the same folder location (i can drag and drop the xlsm file into the folder on each ocassion) and it also creates and output file in the same folder and dumps the unzipped fiels in the output folder.

Im extremely new to VBA... and any help is greatly welcomed.

Thank you kindly.

Leith Ross
11-10-2015, 05:31 PM
Hello ChrisAch,

Are referring to only files with a .zip extension in this folder?