Is workbook open anywhere in network?
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
|