I have a file called DataFile.xlsm, with Sheet1, and date recorded in A1 cell.
In the same directory I have number of other workbooks with date recorded on Sheet "Control", A1 cell.
I'm trying to write macros to loop through all files in the same directory (or directory C:\MOS\)
The aim is to...