File is open on another PC?

Jos Vens · Nov 22, 2004

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 · Nov 23, 2004

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 · Nov 23, 2004

Thanks Dave!!

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"