Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to display Modified properties
Is there a formula I can use that will display the date & time the file was
last modified? Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to display Modified properties
From Gary's Student
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 '=DOCPROPS("last save time") '(format cell as date) "Paul" wrote: Is there a formula I can use that will display the date & time the file was last modified? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display Date Modified | Excel Discussion (Misc queries) | |||
File Properties Modified Date not changing | Excel Discussion (Misc queries) | |||
Display last date workbook was modified? | Excel Discussion (Misc queries) | |||
Display date modified | Excel Discussion (Misc queries) | |||
Display Date Modified | Excel Discussion (Misc queries) |