question for Excel file

[Guest]

Is there a way to tell who and when an Excel file was lasted accessed? I'm able to view by when the last document was saved but not who last accessed the file. Any solutions?

 

[Bob Phillips]

Sam,

You can test the Builtin Document Properties to find who last updated, but
not if just read. This gives the last author in the immediate window

?Activeworkbook.BuiltinDocumentProperties("Last Author")

which should show the technique

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Is there a way to tell who and when an Excel file was lasted accessed? I'm

able to view by when the last document was saved but not who last accessed
the file. Any solutions?

 

[Guest]

How do you accomplish this? Can you give me the steps?

 

[JMay]

In a standard module:

Sub Test()
MsgBox "The last person to update this file was " &
ActiveWorkbook.BuiltinDocumentProperties("Last Author")
End Sub

Watch wrapping above...