Repost: Is Workbook already open?

[GrantW]

This is a repost from 4 days ago. I have searched the discussion group but my
original question seems to have vanished.

Is there any code I can use in my macros to establish if a certain workbook
is already open by another user on our network, regardless if it is "read
only" or not?

Any help would be appreciated.

GrantW

 

[Jim Cone]

Frederik answered your post on the 7th...
"Have a look at
http://www.j-walk.com/ss/excel/tips/tip54.htm
a great source of inspiration!!!
greetz"
---

Jim Cone adds...
Outlook Express is a better way to read and write newsgroup posts...
see:
http://www.michaelstevenstech.com/outlookexpressnewreader.htm
or
http://www.tushar-mehta.com/misc_tutorials/oe_ng/
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"GrantW"
wrote in message
This is a repost from 4 days ago. I have searched the discussion group but my
original question seems to have vanished.

Is there any code I can use in my macros to establish if a certain workbook
is already open by another user on our network, regardless if it is "read
only" or not?

Any help would be appreciated.

GrantW

 

[GrantW]

Thanks for finding his reply,Jim..... I must be having a "seniors day"
Also, thanks for the Outlook tip