Getting file created date (1 Viewer)

[gsrajan]

I am able to get the files names from Windows Explorer using http://allenbrowne.com/ser-59.html function. Is it possible to get the file created date also? Thank you.

 

[Gasman]

Have a look at similar threads at the bottom of this thread.
FileDateTime() would work if the file has not been modified I believe?

Otherwise
https://docs.microsoft.com/en-us/of...ence/user-interface-help/datecreated-property

https://docs.microsoft.com/en-us/of...user-interface-help/datelastmodified-property

HTH

 

[gsrajan]

Thank you, I will try that and let you know.

 

[Pat Hartman]

You can get all properties of a file by using FSO

Dim FSO As New FileSystemObject
Dim fs As Scripting.FileSystemObject
Dim folder As Scripting.folder
Dim file As Scripting.file
Dim filefolder

Set fs = CreateObject("Scripting.FileSystemObject")
Set folder = fs.GetFolder(SourceFolderPath)
Set filefolder = folder.Files

For Each file In filefolder


The code routine is too complicated and long to post so I just pulled out the Dims, sets, and For Each to show you how to reference a file using FSO
Then to get the properties is:

file.propertyname ' you'll get intellisense and DateCreated should be the property you want.


You will need a reference to either Microsoft Scripting Runtime or Microsoft Office xx.o Object Library (I can't remember which offhand)

 

[gsrajan]

Thank you.

 

[Pat Hartman]

You're welcome