Excel already open test
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
|