Posted to microsoft.public.excel.worksheet.functions
|
|
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..
|