Date and time stamp or Version number

[Johm]

Hello!

I don´t know what is possible.

When I print a sheet I will have a version number in some Cell.

Maybe the best (I think) is the date/time in a cell when the file i last changed.
(or last printed)

I have seek information how I can use the result under "File/Property"
(Where You can find Creation date, Last modify, Last Printed and so on)

How can I get some information like this in a Cell?

// Jan

[Mark B]

Hi Jan

A simple macro will do the job (it'll put the timestamp in A1 in Sheet1):

[Johm]

Thank´s for the code!

Now is the problem:
How can I make the macro (in Calc)?

//Jan

[Mark B]

To add a new macro:

• Click on Tool| Macros | Organize Macros | OpenOffice.org Basic;
  
• Select My Macros | Standard | Module1 and then click Edit;
  
• Cut and paste the code above into the new window.
  

To see it in action click in a spreadsheet, then this window and then press the 'Run Basic' button on the toolbar.

Mark
_________________
Mark B's Articles

[Johm]

Thank´s a lot, it works fine

//Jan

[teror]

how can i run a macro with an if...then...stament from another cell?

i want to put a timestamp in a cell when a value has been entered into an adjacent cell

i am doing a survey and entering in prices into one column and i want an automated timestamp to appear next to it when i've entered in the price.

i currently use an if statement to check for a blank cell and then use the Now() function however this updates all previous cells as well. i need the timestamp to stay current after the adjacent cell has been updated.