Check for File Open

[BillCPA]

Is there some way (in VBA) to check to see if a file (spreadsheet) is in use
before you try to open it?

 

[Dave Peterson]

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"

 

[BillCPA]

Thank you. I will experiment with both.

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"