Who has a workbook open

[LiSa]

I have created a workbook that opens a second workbook for
people to enter data.
But if somone else already has this second workbook open
then my workbook opens a read-only copy.
I've got an if statement that prevents people entering
data to a read-only copy, but it would be great to display
the name/ID of the person who does have it open, as would
happen if a person has opened it directly and not via my
workbook.

TIA

 

[pfsardella]

This suggestion by Tom Ogilvy works for me. However, there have been
previous threads concerning reliability,

http://www.google.com/groups?hl=en&lr=lang_en&ie=UTF-8&c2coff=1&safe=off&th=2446150a00d05df4&rnum=5

Tested using Excel 97SR2 on Windows 98SE,

HTH
Paul

 

[Ivan F Moala]

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