Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a last update property of a file.
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a last update property of a file.
? 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 ... 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a last update property of a 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 "Eric" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File Property Keyword Search | Excel Discussion (Misc queries) | |||
Generate File Property | Excel Discussion (Misc queries) | |||
File/custom Property fields | Excel Discussion (Misc queries) | |||
Best way to inser file property into and excel sheet (cell) | Excel Discussion (Misc queries) | |||
Network access to file - read only property | Excel Discussion (Misc queries) |