Display Properties ->Statistics

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Khawar - 28 Jul 2004 03:34 GMT

Good day,

I wanted to find out if there is a way of displaying the
Properties -> Statistics of a workbook on a sheet in the workbook?

I would like to display and automatically update the following statistics.

Created:
Modified:
Accessed:
Printed:
Last Saved by:

Best Regards
Khawar

Reply to this Message

Frank Kabel - 28 Jul 2004 05:40 GMT

Hi
use the following UDF:

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

and enter in a cell
=DOCPROPS("last author")
or
=DOCPROPS("last save time")

Signature

Regards
Frank Kabel
Frankfurt, Germany

> Good day,
>
[quoted text clipped - 12 lines]
> Best Regards
> Khawar

Reply to this Message