question for Excel file

S

sam

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?
 
B

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)

sam said:
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?
 
J

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...
 
Top