Is there a last update property of a file.

[Eric]

Is it possible to have VBA code check the time of last
update of a file to decide wether or not to download a
later version?

 

[Tom Ogilvy]

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

 

[Robin Hammond]

There are various ways to do it, but I save a value in the registry for each
file when it is downloaded using savesetting, my version checker uses
getsetting to compare the date the file was last saved against a database
query which returns a file list with dates from a db, and if the file is out
of date it downloads a newer one using an api call urldownloadtofile.

you could also easily maintain the file list as an excel file, and use
urldownloadtofile to get the file with the latest dates, which avoids all
the db stuff.

Robin Hammond