M Mark Nov 5, 2003 #1 When my macro opens a second Workbook how can the macro determine if the second Workbook is already opened by another user?
When my macro opens a second Workbook how can the macro determine if the second Workbook is already opened by another user?
D Dave Peterson Nov 6, 2003 #2 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"!!!
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"!!!
