Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can keep the modified date record in worksheet
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can keep the modified date record in worksheet
Have a cell set as counter of number of saved times, when you save the
file you increase the counter by 1, then you can have a logic that when the counter is greater than 1, you won't update the modified time. On 11$B7n(B10$BF|(B, $B2<8a(B1$B;~(B10$BJ,(B, Lee wrote: 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 Fun |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can keep the modified date record in worksheet
Thanks for your reply. but how to achieve it? i am the rookie for excel
marco, only know ctrl +P & V. Thanks "Edward" wrote: Have a cell set as counter of number of saved times, when you save the file you increase the counter by 1, then you can have a logic that when the counter is greater than 1, you won't update the modified time. On 11月10日, 下午1時10分, Lee wrote: 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 Fun |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |