Microsoft KB Archive/24562

Time Stamping Spreadsheets PSS ID Number: Q24562 Article last modified on 08-11-1988 PSS database name: D_MPlan

3.00 3.01 3.02

MS-DOS

Problem: I want to write a macro that will put the current date in a cell of my spreadsheet, but will not be updated each time I load the spreadsheet on a new day. If I enter the Now function in a cell, Multiplan puts the current date in the cell. However, as soon as the DOS date changes, this cell is updated to reflect the new date. I need a way to use the Now function to get the current date, then have that date remain until I decide to update it.

Response: You can create a macro that will use the Now function to get the current date. First, place the value (serial date) in a specified cell, then execute and  . This will freeze the date at the date the macro was last executed. This macro also could be used to create personal “date stamps” on documents to remind you when the most recent change to the spreadsheet took place. The following is an example of a macro that would take the current DOS date, place it in R1C1, and freeze it so it would not be updated until you decide to do so:

‘ler1c1’now’’hme’rc’rt’qu

Copyright Microsoft Corporation 1988.