Can you check the last update property of a file?
 

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.

Can you check the last update property of a file?
 

Eric wrote:

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

--
Steve Garman

Can you check the last update property of a file?
 

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.

--
Regards,
Tom Ogilvy



"Eric" wrote in message
...
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.