Re: Record of file access
From: Alan (alan111_at_ntlworld.com)
Date: 09/03/04
- Next message: ...Patrick: "Re: Relative Cell Referencing"
- Previous message: Bob Umlas: "Re: ActiveCell.Offset w/ VBA"
- In reply to: Frank Kabel: "Re: Record of file access"
- Next in thread: Lars-Åke Aspelin: "Re: Record of file access"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 3 Sep 2004 21:30:42 +0100
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" <frank.kabel@freenet.de> wrote in message
news:uWXNqOfkEHA.2804@TK2MSFTNGP09.phx.gbl...
> 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" <frank.kabel@freenet.de> wrote in message
> > news:eJp54EfkEHA.3428@TK2MSFTNGP14.phx.gbl...
> >> 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!)
>
- Next message: ...Patrick: "Re: Relative Cell Referencing"
- Previous message: Bob Umlas: "Re: ActiveCell.Offset w/ VBA"
- In reply to: Frank Kabel: "Re: Record of file access"
- Next in thread: Lars-Åke Aspelin: "Re: Record of file access"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|