Hi Michael

You could perhaps open it readonly with code and check its "WriteReservedBy"
property to identify the read-write user. Perhaps, because this works well
on some networks and not at all on other. Which is said to be caused by "how
the network is built", I know nothing about those things.

If macros are enabled by the users, I think I'd code something in the file
to write the username to a log file on open/close.

--
HTH. Best wishes Harald
Followup to newsgroup only please

"Miochael Bond" skrev i melding
...
Good morning

I have a workbook located on a network directory to which
many users have access.

I am writing additional code to update that wokbook from
time to time.

I want to be able to tell, before any action is taken, if
anyone already has the workbook open, either "read only"
or "read/write"

Is is possisble to do this....and if so can the user who
has it open "read/write" be identified.

The file is not shared.

Using Win2000 and Excel2000

Thanks and regards

Michael Bond