Record of file access

[Alan]

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!)

 

[Frank Kabel]

Hi Alan
I would not do this within Excel (the easiest way to circumnvent the
logging is to disable macros). Do this on operating system/network
level.

 

[Lars-Åke Aspelin]

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!)

Maybe something like this:

Private Sub Workbook_Open()
Open "logfile.txt" For Append As #1
Print #1, ActiveWorkbook.Name & "," & Application.UserName & _
"," & Date & "@" & Time()
Close #1
End Sub

Lars-Åke

 

[Alan]

Hi Frank,
I do know that as I said originally, but I don't have access to the
operating system on the Company Network and the IT people I deal with are
less than helpful. Is it possible within Excel?
Regards,
Alan.

 

[Frank Kabel]

Hi
as said you can do something in your workbook open event BUT if the
user disables macros it would be useless

 

[Alan]

Thanks Lars!
Thats exactly what I wanted,
Warm Regards,
Alan.

 

[Alan]

Hi again Frank,
I KNOW THAT! I can get round that! I'm not dealing with experts, if I were
it would be a different matter. I can easily make the workbook useless
without Macros Enabled.
I could easily overcome that as could you, but the people I'm dealing with
would not even try, its not a matter of National Security,
Regards and Thanks,
Alan.