Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want to have my macro code determine the date a file was last updated and
then from there, decide whether or not to open it. What I don't know is how to access the file's property that returns that date it was updated. If I could just use an "If" statement to say something like this, in principle: If Filename.DateUpdated = Today() - 1 Then Workbooks.Open Filename End If The goal is to only open files that have been updated within the last two days. Is this possible? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Evaluate Date for 21st birthday | Excel Discussion (Misc queries) | |||
date last updated | New Users to Excel | |||
Date last saved/updated | Excel Programming | |||
How many copies of a file can be updated by the "File/Save" comma. | New Users to Excel | |||
How do I keep the date from being updated every day | Excel Discussion (Misc queries) |