Re: another macro is running ... how to recognise that process in code
- From: Matthew Dodds <matthewgdodds@xxxxxxxxxxx>
- Date: 23 Apr 2007 08:39:10 -0700
Thanks Tim, I think you're right; but simultaneous AddIn runs isn't
the issue.
What I wanted to do was to recognise in code when AddIn_1 was running,
and stop the eventCapture enabled by AddIn_2 from being triggered (my
AddIn_2 uses activation of a work*** created by AddIN_1 to create a
menu; since AddIn_1 repeatedly activates this *** during its own
run, this causes problems if my AddIn_2 is installed at the time)
Any ideas anyone ....?
On 20 Apr, 07:41, "Tim Williams" <timjwilliams at gmail dot com>
wrote:
As far as I know only one VBA procedure can run at a time, so add-in1 should
not be running when your code (add-in2) runs.
That said, it doesn't always appear that way and crashes or hangs can be
tricky to avoid in these circumstances.
Tim
"Matthew Dodds" <matthewgdo...@xxxxxxxxxxx> wrote in message
news:1176998072.621780.107740@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Thanks Madhan, I haven't come across the autolist feature, and F1
offers no help; how do I go about using it?
Thanks
Matthew
On 18 Apr, 16:44, Madhan <Mad...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Hi, in my opinion, any AddIn will expose its methods and properties. You
should try using the autolist feature of VBA to find out its methods,
which
might help you in understanding how it works.
"Matthew Dodds" wrote:
I have written an AddIn (call it AddIn_2) which picks up where another
(AddIn_1) leaves off.
AddIn_2 uses events to identify when a particular work*** is
activated to enable a menu item.
AddIn_1 creates that work*** and reiteratively activates it during
its process ... causing a messy crash. AddIn_1 is a commercial product
and I have no access to its code.
I want to be able to write a clause like
if AddIn_1 is running
end if- Hide quoted text -
- Show quoted text -- Hide quoted text -
- Show quoted text -
.
- Follow-Ups:
- References:
- another macro is running ... how to recognise that process in code???
- From: Matthew Dodds
- Re: another macro is running ... how to recognise that process in code
- From: Matthew Dodds
- Re: another macro is running ... how to recognise that process in code
- From: Tim Williams
- another macro is running ... how to recognise that process in code???
- Prev by Date: RE: Odd macro behavior
- Next by Date: Re: Connection from Excel to SQL
- Previous by thread: Re: another macro is running ... how to recognise that process in code
- Next by thread: Re: another macro is running ... how to recognise that process in code
- Index(es):