I have referred someone on how to loop through workbooks in a folder to this site. See if this helps.
Loop Through All Excel Files In A Given Folder
This VBA macro will let you select a folder path and loop through each of the Excel files in the folder. The macro code opens each Excel file, performs a task, saves the file, and then closes the workbook.www.thespreadsheetguru.com
Glad to helpThanks that worked well, I now need to amend this to give a list of workbooks that didn't get updated and for what reason, ie someone was in the file etc