How can I determine who has workbook open?

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

Guest

Hello,

I currently use the readonly property of the workbook to determine that the
workbook is already opened by another user. But how do I know who that other
user is? The writereservedby is empty, so I know that won't help. Any ideas?

Thanks, Dean.
 
I know Excel can tell you who has a workbook open when is prompts fotr Read
Only, Notify or Cancel. So I was hoping to use the same function. Do you
think this might work by doing some coding with the File System Object (FSO)?

Regards, Dean.
 
No. I doubt it. I think you would have to go to the API if it is available
there and you have access to that information.

Regards,
Tom Ogilvy
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Determine if workbook is open 2
File in use by ? WHO ????? 2
How to display the user "locking" a workbook or an addin. 1
code to open another workbook 3
How to determine which sheets appear on opening a workbook. 6
Determining who has an Excel file open 1
Determine if a shared workbook is open 1
Determining the number of open workbooks 6

Back
Top