Hello,

I have another thread posted that is similar, but this is a separate issue that I would love some help with.

I would like to check multiple folders for a certain file based on the date (current daily report filed in different folders based on the month/year. In other words we do a daily report and save it in a folder based on year/month. IE ...\2014\January\DailyReport_1.2.14.xlsm. In this report is a range of cells that show if certain safety drills are current. I would like to have excel find the current days file, look at the drills section to see if a drill is current or not, and then show a different state bases on the answer (true/false?)

Can someone point me in the right direction of how to begin doing this? Is it possible? Any specific code examples would be fantastic!

Thanks so much,