Finding File Time

If I have, say, in a Cell the formula =Cell(FileName",A1), that generates the name of the curreent file.

Or I might have, in a Cell, a "Value" such as
="C:\MyFolder\MyFile.TXT"

How can I use this value to find the "Date / Time " stamp?

Yes, I know there are several "styles" of these -
Created, Modified, Accessed, archived, completed, last saved, received, released, sent, taken, deleted, any more ?
so I also need to be able to specify which style.

I haven't managed to find a "built-in" function - is there one ?

So - if not - some ideas, please, for a VBA Function, so that I can use the formula
= FileTime ( B3, myStyle )

And of course I would then want to modify that for FileSize, FileShortName and FileAttr ;-)

Here is a VBA that you can modify for your particular objects you wish to find. It should give you an idea of a possible direction to pursue if I am understanding your request.

Please Login or Register  to view this content.

You can access following 3 datetime using Scripting.FileSystemObject.
DateCreated, DateLastModified, DateLastAccessed

Archived is just an attribute on the file object and note datetime. Assuming it was archived, then last modified should be the archived date.
Other datetime / attributes you listed, does not exist in file object record.

Ex:

Please Login or Register  to view this content.