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.
 
You must log in or register to reply here.

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

Similar Threads

Import File Information 0
Outlook Looking for macro to save multiple emails as .msg to folder and extracting the invoice ref. from the email body as the filename 4
Use current date to save archival import source file Access 2007 2
Need help in VBA for embedded object in excel 1
Choose folder with largest filename number 1
Copy of File in filesearch result 6
Using IF formula with dates 0
Command Line to Open/Close an Excel Files , macro print it in a designated Folder 1

Back
Top