Multi-Users and VBA

  • Thread starter Thread starter Nigel
  • Start date Start date
N

Nigel

Advice please.

I have an application running on a network server that is accessible by a
number of different users.
I only ever want one person to use it at a time, and if another attempts to
open it I want VBA to deliver a message.

Presently the standard message created by Office, which tells the use
another user is modifying , do you want to open it read-only etc., is what
they see. Can I intercept this message and control whether they can open it
or not - even if read only ?

TIA

Cheers
Nigel
 
Hi Nigel

Lousy no-good reply, but a reply:

There's a VBA property for workbooks named "WriteReservedBy" that's supposed to return the
name of the one "really" using it. Now this works perfect at all times on some systems,
never ever on other systems. And it's said to have something to do with how the network is
built. You never can tell.

I've always been on not-too-well-built networks, so I've never seen it working. And so I
have no idea wether a macro would run before the prompt, or if you can open the file by
code and catch it there. But try opening a file that you really know is in use right now
by someone else, and see i this property returns some other name than your own. If it
does, that's at least something to build on -you have a great network and a vision :-)
 
Back
Top