Get Date of when File was created.

[Pc_Madness]

How can I get the date of when a file was created.

[Buzby]

I think the function is GetFileDateTime or something like that.

[pnish]

You can use the FileSystemObject which is part of the scripting runtime, ie add a reference to Microsoft Scripting Runtime.

Dim fso As FileSystemObject
    Set fso = New FileSystemObject
    Debug.Print fso.GetFile("myfile.dat").[B]DateCreated[/B]

You can also use, DateLastModified and DateLastAccessed among others.

Cheers

[Pc_Madness]

Sweet, thanks.