TomW wrote: > James Knott wrote: >> I currently use the =today() function in a spreadsheet. However, >> I've noticed it always shows the current date. Is it possible to >> have it show the date of the last save? >> >> tnx jk >> > One solution would be the following: > > If you assign a macro similar to the one listed below to the close > event of the worksheet, you can insert the current Date/Time into a > cell on the worksheet. The workbook events are accessible through the > tools:customize:events tab.
What I'm looking for is just the saved date, which is not necessarily the same as the close date. That is, if I save the document, the date shows that, and does not ever change, until I do another save later. The =today() function will show last modify date, which is close enough, but unfortunately also changes on re-opening the file, which is not what I want. Is there any way to read the file modify date into the cell? tnx jk -- Use OpenOffice.org <http://www.openoffice.org> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
