How can I access/display File -> properties in a cell
 

How can I access and display, from within a worksheet cell, the modified date
in FIle-Properties? In Word you can insert the "Field" in the document. How
can this be done in Excel?

Thanks,
Denny

You need a udf

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


You would use like so

=DOCPROPS("last save time")


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Denny" wrote in message
...
How can I access and display, from within a worksheet cell, the modified
date
in FIle-Properties? In Word you can insert the "Field" in the document.
How
can this be done in Excel?

Thanks,
Denny