Good idea....that will work, thanks


-----Original Message-----
Hi Michael,

This is just an idea but please try something like this.
When a user open the workbook, output a text file to
network directory via
VBA.
When a user close the workbook, kill that text file.

When you would like to update the file, check if the text
file exist or not.

Regards,
Colo

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


.