=LMD() to include time

  • Thread starter Thread starter GerryK
  • Start date Start date
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
 
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
 
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
 
Gerry

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

Function LMD()
Application.Volatile
 
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...
 
Back
Top