Insert File Properties

[JB]

Is it possible to insert a file property (e.g. Title,
Subject, Author) into an Excel worksheet cell for display,
similar to inserting a field in Word? Thus the value could
be centrally managed yet appear multiple locations where
inserted throughout the document.

 

[Frank Kabel]

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")