How to determine if Workbook has been opened exclusively

[robot]

Hi All,

Using VBA code, how to determine if a workbook in a shared folder has been
opened exclusively by someone else?

(I use Excel XP and Win XP pro)

 

[Dave Peterson]

I think you want this:

MS has code here that checks to see if any file is open:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q138621
XL: Macro Code to Check Whether a File Is Already Open (Q138621)

 

[Ivan F Moala]

Hi All,

Using VBA code, how to determine if a workbook in a shared folder has been
opened exclusively by someone else?

(I use Excel XP and Win XP pro)

Have a look here to check to see if Workbook is Open AND by who.

http://www.xcelfiles.com/IsFileOpen.html