Track Date Created & Last Modified Dates
 

Is there any way of getting the Date Created & Last Modified Dates for an
Excel file so that I can create a summary report of time spent on on a file?

Track Date Created & Last Modified Dates
 

for a closed file

Sub ABB()
Dim fso As New FileSystemObject
Dim f As File
'Get a reference to the File object.
Set f = fso.GetFile(Environ("windir") & "\system.ini")
Debug.Print f.DateCreated
Debug.Print f.DateLastAccessed
Debug.Print f.DateLastModified
End Sub

Requires a reference to the Microsoft Scripting Runtime or modify to use
late binding

Dim fso as Object, f as Object
Set fso = CreateObject("Scripting.FileSystemObject")

Otherwise, you might be talking about the build in document properties

http://www.cpearson.com/excel/docprop.htm

--
Regards,
Tom Ogilvy


"TonyD" wrote in message
...
Is there any way of getting the Date Created & Last Modified Dates for an
Excel file so that I can create a summary report of time spent on on a
file?