How To Determine Filename Saved Date

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

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


Thank You,

G
 
Use the FileDateTime function.
Click to expand...

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.
 
David W. Fenton said:
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.
Click to expand...

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.
 
Back
Top