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
|