pipSeeker
-
Posts
2 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Posts posted by pipSeeker
-
-
Environment: Windows XP/Excel 2007/ MacroExpress 3.7d build 1
***
Will try my best to explain the problem with a scenario...
In Excel 2007, I have two Command Buttons, BtnA and BtnB. Each has been programmed using Excel VBA to call separate macros in Macro Express 3.x, say BtnA calls MacroA and BtnB calls MacroB.
When I press BtnA, it calls MacroA - correct behavior
Then I press BtnB, it calls MacroB - correct behavior
Let us say, I now press BtnA. It should call MacroA, but instead it calls the last played macro, MacroB - inconsistent behavior
I again press BtnA, this time it calls the correct macro, MacroA - correct behavior
It seems as if there is a time lag somewhere in the API call threads, that there is a persistence of previously called macro that leads to above inconsistent behavior. Sometimes it behaves fine, other times, "sticky" behavior as above is exhibited.
Would really appreciate any pointers to resolve as it is key for my project that this API calls work!
Regards, and thanks in advance!
pipSeeker
Windows API call from Excel 2007 is "sticky" causing inconsistent behavior
in Macro Express 3.x
Posted
Any pointers would be really appreciated!
The "sticky" inconsistent behavior occurs even if there is more than a minute's gap between calling the two macros. Quite baffled with why this is happening, frankly!