File is open on another PC?

[Jos Vens]

Hi,

how can you check if a file is open on another PC?

I get the ennoying message to open the file ReadOnly, but if it is open by
another user, I simply don't want Excel's message but my own.
Application.DisplayAlerts doesn't suppress the messagebox from excel.

Can you help?
Jos Vens

 

[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"

 

[Jos Vens]

Thanks Dave!!

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"