How To Determine Filename Saved Date

[Gary]

How can I determine the date a filename has been save last in a directory??


Thank You,

G

 

[Douglas J. Steele]

Use the FileDateTime function.

 

[David W. Fenton]

Use the FileDateTime function.

I just wanted to point out that this is a built-in VBA function, not
something borrowed from the File System Object. That means no added
reference or late binding. I only use the FSO for things the
VBA.FileSystem functions cannot do.

 

[Douglas J. Steele]

I just wanted to point out that this is a built-in VBA function, not
something borrowed from the File System Object. That means no added
reference or late binding. I only use the FSO for things the
VBA.FileSystem functions cannot do.

Good point, David. I, too, avoid using FSO as much as possible: I'd much
rather use API functions than FSO when the VBA functions don't suffice.