Hi,
I'm using a Windows Networked company system where users each have their own
private bit of the hard drive and also a Public Drive which anyone can
access.
On this Public Drive are several read only Excel Files that multiple users
access on a regular basis.
My query is, would it be possible to obtain a log of who has accessed these
files and when? Obviously the files would not be saved on closure as they
are read only.
If this isn't possible, could it be done if the files were saved, ie not
read only, or even with a Workbook close event to force a save? (I know that
wouldn't work if the files were opened with Macro's Disabled, but that
wouldn't really be a problem)
Any advice gratefully received,
Regards,
Alan.

Office XP
Wndows NT (I think!)