Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detecting open workbook
My application is stored on a server that can be accessed by a number of users.
When the workbook is already in open by a user and another person opens it, they get the warning to either not open, be notified or open as read only. How can I detect this and force the workbook to open as read only in VBA code? I need to detect it as I want to control the workbook save/close events and ignore any changes. Cheers |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detecting open workbook
I am not sure you can detect that, but in the events you can do
if thisworkbook.ReadOnly then exit sub -- Regards, Tom Ogilvy "Nigel RS" wrote: My application is stored on a server that can be accessed by a number of users. When the workbook is already in open by a user and another person opens it, they get the warning to either not open, be notified or open as read only. How can I detect this and force the workbook to open as read only in VBA code? I need to detect it as I want to control the workbook save/close events and ignore any changes. Cheers |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detecting open workbook
Hi Tom
That is a pity. What you are saying is that after the user chooses READ ONLY, only then can I detect a read open status. Is there another way of testing if a server file is already open? I could then create a local application that runs a test before it goes off and opens the remote file. Or do I run into the same issue again? Cheers Nigel "Tom Ogilvy" wrote: I am not sure you can detect that, but in the events you can do if thisworkbook.ReadOnly then exit sub -- Regards, Tom Ogilvy "Nigel RS" wrote: My application is stored on a server that can be accessed by a number of users. When the workbook is already in open by a user and another person opens it, they get the warning to either not open, be notified or open as read only. How can I detect this and force the workbook to open as read only in VBA code? I need to detect it as I want to control the workbook save/close events and ignore any changes. Cheers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Not detecting Open Workbook - Why | Excel Discussion (Misc queries) | |||
Not Detecting Open Workbook Status - Odd?? | Excel Discussion (Misc queries) | |||
Detecting if a Window/Workbook is Open | Excel Discussion (Misc queries) | |||
detecting open excel apllications and api qn | Excel Programming | |||
Detecting open files | Excel Programming |