'-----------------------------------------------------------------
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 such as
=DocProps ("last author")
or
=DocProps ("last save time")


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"AlwaysFroosh!" wrote in message
...
This should be pretty straight forward, but I can't find it for the life
of
me. I have a document with a bunch of properties, and I want these
properties
to be displayed in certain cells on my spreadsheet. What formula can I use
to
retrieve the document property??
Thanks