| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get the date a file was modified
Is it possible to get the date when a file was last modified
programmatically in VBA? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Get the date a file was modified
filedatetime
but not the workbook that is open - that always has the date and time when it was opened. It you open it read only I believe it will have its last saved time. -- Regards, Tom Ogilvy "JustinP" wrote in message oups.com... Is it possible to get the date when a file was last modified programmatically in VBA? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Get the date a file was modified
JustinP wrote:
Is it possible to get the date when a file was last modified programmatically in VBA? Using a FileSystemObject, the GetFile method will return a File object, from which you can query the DateLastModified property. Bob -- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for file modified date | Excel Discussion (Misc queries) | |||
| Date modified changes when file not saved | Excel Discussion (Misc queries) | |||
| insert the date the file was last modified | Excel Discussion (Misc queries) | |||
| date file modified | Excel Discussion (Misc queries) | |||
| insert the date the file was last modified | Excel Discussion (Misc queries) | |||
Hybrid Mode
