Detect if a "worksheet file" is already in use

[DiverDan]

Hi,

 

I have a program that saves worksheet type files. How can I detect if a worksheet file is already in use by another user on a network? In other words, if worksheet file A is being used by User A, if User B tries to open worksheet file A I can display a message box that the file is already in use by another User.

 

Thanks,

Dan

[mark007]

Not sure if you are talking about Excel or not ut this Leagcy VB code might give you some ideas:

 

http://www.thecodenet.com/articles.php?id=9

[DiverDan]

Thanks for the reply Mark007!!!

 

Although my app is not Excel, your post did give me a lot of ideas that solved the problem.

 

Thanks for your help!

Dan