Can you check the last update property of a file?

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

Does VBA allow you to check the last update property of a
file to determine whether or not a later version is
available?
I want to look at the last time a file was updated and if
it is more than one day old I want to have it
automatically download the latest version.
 
Eric said:
Does VBA allow you to check the last update property of a
file to determine whether or not a later version is
available?
I want to look at the last time a file was updated and if
it is more than one day old I want to have it
automatically download the latest version.
Click to expand...

You can use filedatetime for this
 
Answer hasn't changed from yesterday when you asked this:

? filedatetime("c:\data1\alex2.xls")
7/10/2003 5:18:35 PM


Should give you the date and time when the file was last saved for a closed
file.
 
Back
Top