Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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.



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35
Default 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.




  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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.






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to: Open closed workbook/Search data tables/Return data to open workbook Hugh Adams Excel Discussion (Misc queries) 0 August 18th 10 02:04 PM
how do i open a data workbook when i open a timesheet workbook [email protected] uk Excel Discussion (Misc queries) 2 January 4th 09 04:50 PM
Open JPG and determine pixel width in VB? Joe HM Excel Programming 5 March 25th 05 04:43 PM
Determine if a workbook is shared quartz Excel Programming 3 March 2nd 04 10:23 PM
Determine if Workbook is Open or Closed jurgenC![_2_] Excel Programming 2 December 28th 03 10:12 PM


All times are GMT +1. The time now is 11:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"