| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.. |
|
#6
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.. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| List of functions contained in the add-ins, esp. Analysis Toolpak | Excel Worksheet Functions | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
| Mileage Claim Formula | New Users to Excel | |||
| run a macro in a locked cell | Excel Discussion (Misc queries) | |||
Linear Mode
