troubleshooting Question

Excel formula or script to verify file date modified is today

Avatar of Kevin Buckland
Kevin BucklandFlag for United States of America asked on
Microsoft OfficeVBAMicrosoft ExcelOutlook
12 Comments1 Solution130 ViewsLast Modified:
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

Thank you.
ASKER CERTIFIED SOLUTION
Shums
Excel VBA Developer
Join our community to see this answer!
Unlock 1 Answer and 12 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 12 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros