Is there a last update property of a file.

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

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