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

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.

--
Regards
Frank Kabel
Frankfurt, Germany


Alan wrote:
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!)

On Fri, 3 Sep 2004 20:52:58 +0100, "Alan"
wrote:

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

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" wrote in message
...
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.

--
Regards
Frank Kabel
Frankfurt, Germany


Alan wrote:
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!)

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

--
Regards
Frank Kabel
Frankfurt, Germany


Alan wrote:
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" wrote in message
...
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.

--
Regards
Frank Kabel
Frankfurt, Germany


Alan wrote:
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!)

Thanks Lars!
Thats exactly what I wanted,
Warm Regards,
Alan.
"Lars-Åke Aspelin" wrote in message
...
On Fri, 3 Sep 2004 20:52:58 +0100, "Alan"
wrote:

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

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.
"Frank Kabel" wrote in message
...
Hi
as said you can do something in your workbook open event BUT if the
user disables macros it would be useless

--
Regards
Frank Kabel
Frankfurt, Germany


Alan wrote:
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" wrote in message
...
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.

--
Regards
Frank Kabel
Frankfurt, Germany


Alan wrote:
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!)