Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
another macro is running ... how to recognise that process in code???
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 worksheet is activated to enable a menu item. AddIn_1 creates that worksheet 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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
another macro is running ... how to recognise that process in code
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 worksheet is activated to enable a menu item. AddIn_1 creates that worksheet 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
another macro is running ... how to recognise that process in code
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 worksheet is activated to enable a menu item. AddIn_1 creates that worksheet 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
another macro is running ... how to recognise that process in code
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 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 worksheet is activated to enable a menu item. AddIn_1 creates that worksheet 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 - |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
another macro is running ... how to recognise that process in code
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" wrote in message oups.com... 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 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 worksheet is activated to enable a menu item. AddIn_1 creates that worksheet 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 - |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
another macro is running ... how to recognise that process in code
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 worksheet created by AddIN_1 to create a menu; since AddIn_1 repeatedly activates this sheet 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" wrote in message oups.com... 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 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 worksheet is activated to enable a menu item. AddIn_1 creates that worksheet 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 - |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
another macro is running ... how to recognise that process in code
So you mean "loaded" rather than "running" ?
Tim "Matthew Dodds" wrote in message oups.com... 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 worksheet created by AddIN_1 to create a menu; since AddIn_1 repeatedly activates this sheet 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" wrote in message oups.com... 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 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 worksheet is activated to enable a menu item. AddIn_1 creates that worksheet 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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel window closed but process still running | Excel Programming | |||
How to Check if a Process is Running | Excel Programming | |||
How to count process running time ( process not finished) | Excel Programming | |||
How to count process running time ( process not finished) | Excel Programming | |||
Excel process remains running | Excel Programming |