Workbooks in use
 

Greetings
I would like to be able to tell who has a workbook open an
notify the user. I can find out that the file (workbook) is in open,
(by issuing a file open and trapping error #70) and tell the user that
but I'd like to be able to tell the user who has it open like Exce
does when manually opening the file from the menu.
Anyone know how to do this
TIA
-Georg

Workbooks in use
 

Yes you could find some way to set up a net send comand and tell them.

Do a search for net send on this site and it should pop up some goo
info.

Keith
www.kjtfs.co

--
Message posted from http://www.ExcelForum.com

Workbooks in use
 

Open the workbook read only and test the writereservedby property.

It works for me, but others have said it doesn't work for them. Other than
that, there is no built in Excel VBA method I am aware of.

--
Regards,
Tom Ogilvy

Dire Wolf wrote in message
...
Greetings,
I would like to be able to tell who has a workbook open and
notify the user. I can find out that the file (workbook) is in open,
(by issuing a file open and trapping error #70) and tell the user that,
but I'd like to be able to tell the user who has it open like Excel
does when manually opening the file from the menu.
Anyone know how to do this?
TIA,
-George