Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Time Date Last Modified
I am sharing a worksheet with another person and we both are updating it
often throughout the day. I'd like to have a cell display the last time and date it was modified. Can this be done? Thanks, Diane |
#2
|
|||
|
|||
Only by using VBA
http://tinyurl.com/apq8b Regards, Peo Sjoblom "LDL" wrote: I am sharing a worksheet with another person and we both are updating it often throughout the day. I'd like to have a cell display the last time and date it was modified. Can this be done? Thanks, Diane |
#3
|
|||
|
|||
Here is an UDF
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 Now you can use the following formula in one of your cells: =DocProps("Last save time") Obviously, the file has to have been saved. -- HTH Bob Phillips "LDL" wrote in message ... I am sharing a worksheet with another person and we both are updating it often throughout the day. I'd like to have a cell display the last time and date it was modified. Can this be done? Thanks, Diane |
#4
|
|||
|
|||
Peo and Bob, Thank you both for your responses. Diane
"Bob Phillips" wrote in message ... Here is an UDF 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 Now you can use the following formula in one of your cells: =DocProps("Last save time") Obviously, the file has to have been saved. -- HTH Bob Phillips "LDL" wrote in message ... I am sharing a worksheet with another person and we both are updating it often throughout the day. I'd like to have a cell display the last time and date it was modified. Can this be done? Thanks, Diane |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically enter date and time but only update once. | New Users to Excel | |||
Help - Information with time and date | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) |