Get the date a file was modified
 

Is it possible to get the date when a file was last modified
programmatically in VBA?

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?

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