I am using a Log to store data which is generated by users
The Log (Workbook) is opened, data is written and then the Log is closed (a brief opperation).
My users are on a network and there is a possibility that the program will try to open the Log when another user has it open (ie Duplicate copies of the code can be exicuting at the same time)
I need some way to detect in the VB code if the Log is open then loop till it closes then open it so I avoide clashes.
I have had a look at previous postings but I can't seem to find the answer.
Can anyone Help