time stamping & tracking

[Guest]

When working in Excel is it possible to do either of the following things:

1) Have a template continually update date and time but then freeze that date and time upon saving the individual file? When I use NOW() it does not freeze the time after it is saved.

2) Is there a formula that will caculate/track every time you open the same document (such as automatically increasing the last invoice number by 1)?

Thanks for your help!

 

[frank stone]

1. the only way i know to do that is to copy the =now()
date and paste it as values. (edit>pasteSpecial>values)
2. And auotrun macro might add 1 to a certain cell when
you open the file.

-----Original Message-----
When working in Excel is it possible to do either of the following things:

1) Have a template continually update date and time but

then freeze that date and time upon saving the individual
file? When I use NOW() it does not freeze the time after
it is saved.

2) Is there a formula that will caculate/track every time

you open the same document (such as automatically
increasing the last invoice number by 1)?

 

[Frank Kabel]

Hi
for the first question see:
http://www.mcgimpsey.com/excel/timestamp.html

For the second question. Put the following code in your workbook
moudle:
sub workbook_open()
with me.worksheets("sheet1").range("A1")
.value=.value+1
end with
end sub