View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Miochael Bond Miochael Bond is offline
external usenet poster
 
Posts: 1
Default Is workbook open anywhere in network?

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