| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to set text property of a check box to value of a cell? | Charts and Charting in Excel | |||
| Generate File Property | Excel Discussion (Misc queries) | |||
| File/custom Property fields | Excel Discussion (Misc queries) | |||
| Is there a last update property of a file. | Excel Programming | |||
| How to check if SHEET has QUERYTABLE property ? | Excel Programming | |||
![Eric[_14_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
