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
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" <[email protected]> wrote in message
news:[email protected]...
> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks