Workbooks in use

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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.
 
Back
Top