How can I determine who has workbook open?
 

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.

How can I determine who has workbook open?
 

That is it as far as built in capabilities.

--
Regards,
Tom Ogilvy


"Dean Hinson" wrote in message
...
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.

How can I determine who has workbook open?
 

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.

"Tom Ogilvy" wrote:

That is it as far as built in capabilities.

--
Regards,
Tom Ogilvy


"Dean Hinson" wrote in message
...
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.

How can I determine who has workbook open?
 

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

"Dean Hinson" wrote in message
...
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.

"Tom Ogilvy" wrote:

That is it as far as built in capabilities.

--
Regards,
Tom Ogilvy


"Dean Hinson" wrote in message
...
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.