View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Last Save Date & Time

Ruan,

You need a VBA function:

Function LastSaveTime() As Variant
LastSaveTime = ThisWorkbook.BuiltinDocumentProperties("Last Save
Time").Value
End Function

Then, call this from a worksheet cell with =LastSaveTime() .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com


"Ruan" wrote in message
...
Hello,

Is it possible to display the "Last Save Date and Time" of an Excel

workbook
to a specific cell?

Thanks
Ruan