| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How do I enter the creation date in Excel, rather than current da.
|
|
#2
|
|||
|
|||
|
Function CreaDate() As Date
CreaDate = ActiveWorkbook.BuiltinDocumentProperties("Creation date") End Function Usage is: =CreaDate() OR more options.... Function DocProps(prop As String) Application.Volatile On Error GoTo err_value DocProps = ActiveWorkbook.BuiltinDocumentProperties(prop) Exit Function err_value: DocProps = CVErr(xlErrValue) End Function Usage is: =DocProps("last author") =DocProps("last save time") =DocProps("creation date") Gord Dibben Excel MVP On Thu, 27 Jan 2005 10:59:05 -0800, Tazman wrote: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Automatically enter date and time but only update once. | New Users to Excel | |||
| How do I enter a date before 1900 in excel? | Excel Worksheet Functions | |||
| How do I enter a date before 1900 in excel? | Excel Worksheet Functions | |||
| Excel: How do I enter a date in one cell & automatically dates adj | Excel Discussion (Misc queries) | |||
Hybrid Mode
