Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I just learnt how to use the function as below to show the " last modified
date", but how can I keep record not changed next time? For example, at the first time I inputed the data and save, it will show me the time once I closed and opened it. But the second time, the time will show me the latest modified time but not the time at the first modification. How can I keep that not update next time? '----------------------------------------------------------------- Function DocProps(prop As String) Dim LastDate As String Dim wbProp As String '----------------------------------------------------------------- Application.Volatile On Error GoTo err_value wbProp = "last save time" LastDate = ActiveWorkbook.BuiltinDocumentProperties(wbProp) DocProps = ActiveWorkbook.BuiltinDocumentProperties _ (prop) Exit Function err_value: DocProps = CVErr(xlErrValue) End Function |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date/Time When content of a Worksheet is Modified | Excel Worksheet Functions | |||
How do I display the 'Date Modified' in an Excel worksheet header | Excel Discussion (Misc queries) | |||
date that a row is modified | Excel Discussion (Misc queries) | |||
How to check who modified a record in Excel | Setting up and Configuration of Excel | |||
How to record macro to print pages modified today | Excel Worksheet Functions |