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

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..

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

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..

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

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..

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

See http://www.cpearson.com/excel/FileTimes.htm to get the file system
maintained file dates and times.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

"driller" wrote in message
...
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..

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

thanks for the reply,sir...


"Chip Pearson" wrote:

See http://www.cpearson.com/excel/FileTimes.htm to get the file system
maintained file dates and times.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

"driller" wrote in message
...
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..

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

i just need to have the exact UDF i can use for...copy/paste
--
*****
birds of the same feather flock together..



"driller" wrote:

thanks for the reply,sir...


"Chip Pearson" wrote:

See http://www.cpearson.com/excel/FileTimes.htm to get the file system
maintained file dates and times.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

"driller" wrote in message
...
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..