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)

I think you want this:

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

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

robot wrote:

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

"robot" wrote in message ...
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