G Guest Nov 23, 2004 #1 Is there some way (in VBA) to check to see if a file (spreadsheet) is in use before you try to open it?
Is there some way (in VBA) to check to see if a file (spreadsheet) is in use before you try to open it?
D Dave Peterson Nov 23, 2004 #2 Ivan F Moala posted this (I didn't try it): Yes you can do this programtically. Have a look here for how to determine if a workbook is Open and by Who. http://www.xcelfiles.com/IsFileOpen.html and MS has a version: 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"
Ivan F Moala posted this (I didn't try it): Yes you can do this programtically. Have a look here for how to determine if a workbook is Open and by Who. http://www.xcelfiles.com/IsFileOpen.html and MS has a version: 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"
G Guest Nov 23, 2004 #3 Thank you. I will experiment with both. Dave Peterson said: Ivan F Moala posted this (I didn't try it): Yes you can do this programtically. Have a look here for how to determine if a workbook is Open and by Who. http://www.xcelfiles.com/IsFileOpen.html and MS has a version: 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" Click to expand...
Thank you. I will experiment with both. Dave Peterson said: Ivan F Moala posted this (I didn't try it): Yes you can do this programtically. Have a look here for how to determine if a workbook is Open and by Who. http://www.xcelfiles.com/IsFileOpen.html and MS has a version: 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" Click to expand...
