Excel formula or script to verify file date modified is today
I receive a daily email which has an Excel attachment that (unfortunately) contains a date with =now(). So whenever you open it, it always shows the current date. I have a macro to save the file to a directory when it comes into my inbox.
Since the excel file comes through with =now(), I need a formula or script in another excel file I use to validate that we received today's file. I assume the best way of going about this is to have a formula or script in Excel display the current date modified and perhaps conditional formatting to highlight if the modified date is <> today.
Alternatively I think I would need a script to open the daily file ("Funding Requirements.XLS") copy | paste special | values so that the =now() formula is no longer contained in the