Date

[Murray]

Is it possible to have a fiels that shows only the date
that the sheet was saved on. It would only update itself
if the workbook was saved.
If I use Now() it updates everytime I open the workbook.

Thanks in Advance
Murray

 

[Frank Kabel]

Hi Murray
put the following code in one of your workbook modules:

Function DocProps(prop As String)
On Error GoTo err_value
DocProps = ActiveWorkbook.BuiltinDocumentProperties (prop)
Exit Function
err_value:
DocProps = CVErr(xlErrValue)
End Function

Now you can use the following formula in one of your cells:
=DocProps("Last save time")

 

[Murray]

Thanks - Danke

-----Original Message-----
Hi Murray
put the following code in one of your workbook modules:

Function DocProps(prop As String)
On Error GoTo err_value
DocProps = ActiveWorkbook.BuiltinDocumentProperties (prop)
Exit Function
err_value:
DocProps = CVErr(xlErrValue)
End Function

Now you can use the following formula in one of your cells:
=DocProps("Last save time")

--
Regards
Frank Kabel
Frankfurt, Germany

.