Get the date a file was modified

J

JustinP

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

Tom Ogilvy

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

Bob O`Bob

JustinP said:
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
--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top