James Knott wrote:
TomW wrote:
James Knott wrote:
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
There is a event called "'Modified' status was changed". You can
assign the macro to that event.
I guess I've have to look into macros then. I've never used them before
in an office package.
tnx jk
I am much more familiar with vba from work, but the first thing I
thought of was 'events' and how to assign code to the events. I am
still struggling with Star Basic and the quirky IDE of OO. I would be
much happier if I could assign a third party IDE to handle the code and
macros. I hit to many dead ends when trying to edit or move macros and
libraries. Some of it may be my limited exposure to coding in other
than vba.
TomW
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
