Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to: Open closed workbook/Search data tables/Return data to open workbook | Excel Discussion (Misc queries) | |||
how do i open a data workbook when i open a timesheet workbook | Excel Discussion (Misc queries) | |||
Open JPG and determine pixel width in VB? | Excel Programming | |||
Determine if a workbook is shared | Excel Programming | |||
Determine if Workbook is Open or Closed | Excel Programming |