possible to check for file in multiple folders, then check for values in specific cells?

This example code opens the DailyReport based on Today's date. Change the root directory ("C:\Reports\") to suit.

Please Login or Register  to view this content.

The description of what you want done with the DailyReport is too vague to follow.

Hey AlphaFrog, thank you for the response. I appreciate your time.

I'll try to explain more clearly, what Im trying to do.

I am making a dashboard that will display on our desk tops in remote offices (all of our offices are remote) to display pertinent information and links to routinely used folders. One of the things on this dashboard will be a list of safety drills. I want to make an icon sitting next to each drill change based on if that drill is up to date or not. I envision a little stop light icon that is red if the drill is out of date and needs to be done, or green if the drill is up to date.

What I want to do is figure out how to have excel look at the value in a specific cell in the current daily report. Then change a conditional macro on my dashboard based on the value in that cell. One thing I need to mention is that the reports are based on the activity of the previous day and named accordingly. In other words todays report is named with yesterday's date. The daily reports will be saved in different folders based on the year and month it is done in. IE C:.../DailyReports/2014/January/DailyReport_1.3.14.xmls. Where the year and month folder will change as time goes on. So I don't want to open the file... I just want to check for a value in a certain cell in the file (IE Sheet name = summary, cell = C42) and then run a macro based on what that value is. One of the things I'd like it to do is constantly check so that the status icon changes in real time.

I hope that makes better sense. And again, I really appreciate your time.