Search for a subfolder

[ajam]

Hello,

I need to search multiple folders to find a specific subfolder with VBA in Excel 2016. Is this possible? The code I use now as you can see below assumes the subfolder is in the 2018 Dec folder but I need to search the 2017 Dec, 2016 Dec and 2015 Dec folders now to see if the subfolder already exists. Any help is greatly appreciated. Thank you.

Please Login or Register  to view this content.

[Sintek]

Hi ajam

This will loop through all folders like 2015 Dec, 2016 Dec, 2017 Dec, 2018 Dec etc in a specified path
and search for your specific subfolder....

Please Login or Register  to view this content.