Can you check the last update property of a file?

[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.

 

[Steve Garman]

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.

You can use filedatetime for this

 

[Tom Ogilvy]

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.