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
FilePropertiesGeneral 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
FilePropertiesStatistics 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..
--
*****
birds of the same feather flock together..



"Gary''s Student" wrote:

Hello again:

Function dates() As String
dates = " created " & ActiveWorkbook.BuiltinDocumentProperties(11)
dates = dates & " updated " & ActiveWorkbook.BuiltinDocumentProperties(12)
End Function
--
Gary's Student
gsnu200703


"driller" wrote:

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.
--
*****
birds of the same feather flock together..