Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All
I have an application that takes control of Excel. That works ok. However if the user already has Excel running, with or without an open workbook, my application which controls the menu and command bars also affect the current workbooks as well. to avoid this I need to detect if this situation exists as my application loads. What I would like to do is as follows.... 1. If an instance of Excel is running, then open another instance - do not use the current one. This is my preference as my application opens in its own environment and does not affect the current open workbooks. 2. If the above is not possible, provide a controlled shutdown of the existing open workbook(s), asking the user to either save or close them. If their choice, on any open workbook, is 'No' then do not open my application and tell the user as much. Is this possible? -- Cheers Nigel |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Test if spreadsheet id open in IE | Excel Programming | |||
Test to see if a workbook is open | Excel Programming | |||
Test if a workbook is open already | Excel Programming | |||
Test that a workbook is open | Excel Programming | |||
test for workbook open | Excel Programming |