If you are looking to see if the workbook has been opened by someone else,
Tom Ogilvy posted this:

-----------------------
You can open it and see if it is readonly, then you will know someone else
is using it.

You can also do:

http://support.microsoft.com?kbid=138621
XL: Macro Code to Check Whether a File Is Already Open

http://support.microsoft.com?kbid=291295
XL2002: Macro Code to Check Whether a File Is Already Open

http://support.microsoft.com?kbid=213383
XL2000: Macro Code to Check Whether a File Is Already Open
---------------------------



"Combo" wrote in message
...


Please help-me!

Are there a function in VBA programming has return if a file of excel
if
already opeded by other user in my intranet?

Tnks!