Syntax for Info or Cell function for xl. file creation date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i cant find it? i need to have a formula that will embed the file creation
date and modfied date in a concatenated formula sentence.
 
Hello again:

Function dates() As String
dates = " created " & ActiveWorkbook.BuiltinDocumentProperties(11)
dates = dates & " updated " & ActiveWorkbook.BuiltinDocumentProperties(12)
End Function
 
hello again too, Gary''silver Student

I place the UDfunction ; the result

"created 4/6/1999 3:38:20 PM updated 1/29/2007 10:41:30 AM"

it do not reflect the correct created data as shown in the
File>Properties>General Tab window"

Created :Friday, January 26, 2007 4:34:30 PM ?????
Modified : Monday, January 29, 2007 10:41:30 AM
Accessed : Monday, January 29, 2007 10:41:26 AM

it only reflect the data as shown in the
File>Properties>Statistics window"
Created :Tuesday, April 06, 1999 3:38:20 PM ?????
Modified : Monday, January 29, 2007 10:41:30 AM
Accessed : Monday, January 29, 2007 10:41:26 AM
Friday, January 26, 2007 4:36:47 PM

----i guess i screw up the file properties since some of my worksheets are
copy/paste from referenced templates workbooks...

is it possible to embed the real creation date of the File as
Created :Friday, January 26, 2007 4:34:30 PM ?????
hope this make sense..
 
Back
Top