Input original save date
 

Is there a way for a cell to display the date the excel document in
question was saved?


--
djarcadian
------------------------------------------------------------------------
djarcadian's Profile: http://www.excelforum.com/member.php...o&userid=15877
View this thread: http://www.excelforum.com/showthread...hreadid=547985

Input original save date
 

Only with a VBA function. Put the following code in a standard
code module.

Function SaveDate()
SaveDate = Format(Application.Caller.Parent.Parent. _
BuiltinDocumentProperties("Last Save Time"), "short date")
End Function

Then call the function from a worksheet with

=SaveDate()


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


"djarcadian"
wrote
in message
...

Is there a way for a cell to display the date the excel
document in
question was saved?


--
djarcadian
------------------------------------------------------------------------
djarcadian's Profile:
http://www.excelforum.com/member.php...o&userid=15877
View this thread:
http://www.excelforum.com/showthread...hreadid=547985