Who saved the file last

[Toni Packard]

Is there a way of finding out who saved a particular file
the last time it was saved? Is there a way to find out
the history of who saved and when?

 

[Bob Phillips]

Activeworkbook.BuiltinDocumentProperties("Last Author")

Can't get a history AFAIK

--

HTH

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

 

[David McRitchie]

Not from Excel unless you already have Track Changes turned
on, or you coded a macro to keep track. Take a look at
properties from within Excel (File, properties).

Highlight, Change Highlighting
http://www.mvps.org/dmcritchie/excel/highlite.htm

You could do your own
http://www.mvps.org/dmcritchie/excel/highlite.htm#beforesave

If the file is on a network drive there may be some logging
as to what is happening.

If you have journaling turned on, which would be bad there would
be some kind of record of something, somewhere, I have no idea
what or where you would see it. But you could contact your
network administrator.