WriteReservedBy Location
 

Hi,

Despite numerous instructions, some of our 80+ users of 30+ networked
PCs insist on 'personalising' their Excel username so that it no longer
matches ther Windows username. I wrote a macro that will change this,
but if they don't run it, it has no effect.

This causes a lot of problems when we come to edit a file and find it
is in use by "Smith" or "Mr X" - no chance of tracking them down in
time.

I'm aware that it is possible to find the username of whoever is
currently editing an open file by checking the WriteReservedBy
property, but given the above I'd need to know WHERE a file is open,
i.e. the computer name rather than the username.

I know that MsgBox Environ("ComputerName") will display MY computer's
name, but can I find the computer name of the machine that has the file
open?

Thanks in advance.