=LMD() to include time

G

GerryK

Hi,
Can this stnd. module macro (a recent Bob Phillips post)
work to display time when the cell is formatted to
m/d/y/h:m?

Function LMD()
LMD = ActiveWorkbook.BuiltinDocumentProperties("Last
Save Time")
End Function

Is there another way to achieve this? (I'm on Excel 2000)

TIA
 
J

Juan Sanchez

Gerry

Bob's macro reports the exact moment of the file was last
saved... so if you format with time in the cell you'll get
the time...

Cheers
Juan
 
G

GerryK

Hi Juan,
Thanks, yes it does that perfectly. When I changed the
cell to display the date and time it did that pefectly as
well, however, subsequent saves that day does not appear
to advance the time component.
I was hoping to get each save (within a day) down to the
minute!

Gerry
 
J

Juan Sanchez

Gerry

You would have to reenter the formula or add this line in
the code

Function LMD()
Application.Volatile
 
G

GerryK

That is wonderful! Thanks!
-----Original Message-----
Gerry

You would have to reenter the formula or add this line in
the code

Function LMD()
Application.Volatile
.
.
.

That will make the formula recalculate every time the
sheet recalculates...

Cheers
Juan



.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date function 2
want to track time while paste value in multiple column of same roe 1
? on "date last saved" in cell 2
Displaying a time value, conditionally. 1
Displaying the current system time - 2nd Try 3
Date and Time Formatting 2
Last Update 2
How to update last save time & last author for each worksheet 7

Top