Who has my Excel Workbook open from VB

[rmedway]

If my spreadsheet is in use by another user and I try to open it manually, Excel pops up a "File in use" dialogue box and nicely tells me that "MyWoorbook.xls" is locked for editing by "UserName". Therefore Excel has the ability to know who has the file open. How can my VB code do the same thing? I need to find the username so that after say, 20 mins, I can send the user a polite email reminding them to exit after use.

Any help would be much appreciated.
Thanks
RUssell

 

[jdc]

Hi

The reason it comes up with "Username" is because whoever has the file open has not customised the office or excel program on this particular pc to give a proper name in the Tools, Options, General, User name box

It usually comes up as Network Admin on the one here where I work which is much use either.

HTH

John

 

[StuLux]

I have exactly the same problem (default user name in this organisation is "Any authorised employee" !!!).

However all users have a unique logon to the system is there anyway of establishing this using code or other software?

 

[jdc]

Hi

Looks like this might be your answer in this link

http://www.mrexcel.com/board2/viewtopic.php?t=168682&highlight=user+logon

haven't tested it myself

John