Re: another macro is running ... how to recognise that process in code

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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" <matthewgdodds@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 -




.

Quantcast