Modified Date
Put it in a regular code module: In the Visual Basic Editor, with your
project selected, choose Insert/Module.
In article ,
debbieevans wrote:
I get the same error "#Name" - what is the solution for this?
"D" wrote:
Where do I put the code in at? I right-click on the worksheet and go to
"View
Code" but when I insert this code into the "ThisWorkbook"
When I insert "DOCPROPS("author") it returns a "#Name?" error
Should I insert the code in the worksheet instead of "ThisWorkbook"
"Gord Dibben" wrote:
D
User Defined Function, not built-in.
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
In a cell enter...........
=DOCPROPS("author")
or
=DOCPROPS("last save time")
Gord Dibben Excel MVP
On Thu, 6 Jan 2005 13:25:07 -0800, "D" wrote:
Is there a way to put in the date when a user saves a document within
the
spreadsheet? So that the next user can see when the spreadsheet was last
saved.
Thanks,
|