Opening a Workbook

Mark · Nov 5, 2003

When my macro opens a second Workbook how can the macro
determine if the second Workbook is already opened by
another user?

Dave Peterson · Nov 6, 2003

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)

And it's even called "IsFileOpen"!!!