LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
lee lee is offline
external usenet poster
 
Posts: 184
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date/Time When content of a Worksheet is Modified Chris G Excel Worksheet Functions 1 October 31st 08 12:06 PM
How do I display the 'Date Modified' in an Excel worksheet header DC Solah Excel Discussion (Misc queries) 3 July 10th 06 06:03 PM
date that a row is modified vaderj Excel Discussion (Misc queries) 1 April 24th 06 10:59 PM
How to check who modified a record in Excel Nic Setting up and Configuration of Excel 1 March 24th 06 09:00 AM
How to record macro to print pages modified today pamiam3333 Excel Worksheet Functions 1 September 10th 05 02:36 AM


All times are GMT +1. The time now is 04:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright 2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"