Re: Prevent multiple instances of Excel from starting
- From: "Peter T" <peter_t@discussions>
- Date: Tue, 21 Feb 2006 00:15:29 -0000
I didn't have any confusion as regards multiple Excel instances vs multiple
xl files. I was trying to ascertain the process involved with your third
party app, and specifically the problem when multiple instances exist (I'm
not trying to imply there isn't a problem).
Does your app call Excel to reference a particular file (which may or may
not be open), or does some event (at application or workbook level) in a
given instance call your app. Or does your app simply require use of Excel
for it's own particular needs, eg calculation, generating files etc.
Depending on what does what to what there might be an easy solution.
FWIW changing Tools ? General > Ignore Other Applications
(xlApp.IgnoreRemoteRequests) will prevent multiple instances starting if
user loads a file from Explorer. But that won't stop all means of starting
multiple instances. Indeed should you prevent user from trying to.
All Office products that run concurrently seem to "know" about each other.
Yes and no!
They interact and react to each other. For example Outlook uses Word to
format emails and spellcheck.
Office apps share common components, but Outlook doesn't start an instance
of Word to use those tools, neither does a given app automatically know what
others are running, and especially how many
Regards,
Peter T
"Robert Mulroney" <''''robert.mulroney@xxxxxxxxx''''> wrote in message
news:8BA53310-0DDE-445C-9752-A79718FCA468@xxxxxxxxxxxxxxxx
Perhaps I didn't make it clear initially, the problem I have stems fromnot
having multiple instances of the "Excel Task" running at the same time,
multiple xl documents.and
To see what I mean: Double click your excel icon. Minimise the window and
double click the icon again. Go to your task manager (sort by task name)
you'll see that there are two instances of Excel processing at the sametime.
That's want I want to prevent, not multiple windows on the start bar.excel
I don't have some malicious intent on making life difficult by randomly
closing peoples work for them. It would be much better to prevent a new
instance starting then have to close it after start - hence my originalprevent
question. The idea of closing tasks came up if it is not possible to
multiple start-ups. In that sence my criteria for closing excel apps wouldbe
"if one is running close the new one and maximise the old"of
All Office products that run concurrently seem to "know" about each other.
They interact and react to each other. For example Outlook uses Word to
format emails and spellcheck. That's one of the coolest things about
developing with Office tools. It's this interaction between two instances
Excel that seem to be causing the problem, confusing the 3rd partyproduct.
Hopefully I'm making more sence. Thanks for you help.
- Rm
.
- References:
- Re: Prevent multiple instances of Excel from starting
- From: Peter T
- Re: Prevent multiple instances of Excel from starting
- From: Peter T
- Re: Prevent multiple instances of Excel from starting
- Prev by Date: Common routine to handle a check box
- Next by Date: Re: Common routine to handle a check box
- Previous by thread: Re: Prevent multiple instances of Excel from starting
- Next by thread: Re: Prevent multiple instances of Excel from starting
- Index(es):
Relevant Pages
|
