Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Last Modification Date
I would like to create a formula that puts the date the file was last
saved/updated. Any help is appreciated Hal |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Last Modification Date
You can't do it with a formula, you'd need VBA code like in 'This Workbook'
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Sheet1.Range("A1") = Date End Sub Regards, Alan. "Hal" wrote in message ... I would like to create a formula that puts the date the file was last saved/updated. Any help is appreciated Hal |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Last Modification Date
'-----------------------------------------------------------------
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 and enter in a cell such as =DocProps ("last author") or =DocProps ("last save time") -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Hal" wrote in message ... I would like to create a formula that puts the date the file was last saved/updated. Any help is appreciated Hal |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding XY days to date in cells | Excel Discussion (Misc queries) | |||
Another Date issue. | Excel Worksheet Functions | |||
Date Math Problem | Excel Worksheet Functions | |||
Excel file modification date | Excel Discussion (Misc queries) | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions |