MrExcel Publishing
Your One Stop for Excel Tips & Solutions

last date modified


Posted by vince on January 30, 2002 10:17 AM

I'm maintaining a common file used by a # of ppl. How can I track the last time the spreadsheet was modified/updated. I've tried the NOW function, but it changes every time the file is opened (and not nec. modified). Any thoughts?


Posted by Matt on January 30, 2002 10:28 AM

Create a macro that runs everytime the file is opened that copies the Now function and paste special as a value to your target cell.

Try.
Open the VB Editor
In the MS Excel Objects: ThisWorkBook add the following:

Workbook_Open()
Range("A1").Select 'Cell where =Now() is
Selection.Copy
Range("B1").Select ' Target Cell
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False ' PasteSpecial value only


Good luck

Posted by Kevin on January 30, 2002 10:44 AM

***You can go to File Properties, and see the date and time when last modified and accessed.

Posted by Jo on January 30, 2002 10:45 AM

Which is better, this Macro or Track Changes?

We have the same thing at our work. We just do track changes. Is this Macro a better way?

Posted by Kevin on January 30, 2002 10:45 AM

***You can go to File Properties, and see the date and time when last modified and accessed.

**** Under the Statistics tab

Posted by Mark w. on January 30, 2002 11:18 AM

You could Share it and Track Changes [nt]