- Joined
- Aug 16, 2002
- Messages
- 6,081
- Office Version
- 365
- Platform
- Windows
Session A is using RTD formulas via an Addin to get stock market data every 2 seconds (I noticed Calculate event runs every 2 seconds).
My code (not the addin) needs to watch for changes in the RTD event. Problem is - when the addin is running, the Calculate event can't run and vice versa.
My solution would be to have 2 separate sessions of Excel. Session A lets the addin do its thing while Session B would watch Session A for changes and run its code.
Can anyone think of potential issues with this solution? I've tested by created the two sessions, running (and pausing) code in 1 session while triggering an event in the other - and seems to work fine. Now, obviously, I won't be able to use an event in session 2 to capture the updating in session 1.. unless I use a class module to capture application level events in session 1.... ok, a few things to think about but - back to the question - anyone experienced and know of issues I need to be aware of?
My code (not the addin) needs to watch for changes in the RTD event. Problem is - when the addin is running, the Calculate event can't run and vice versa.
My solution would be to have 2 separate sessions of Excel. Session A lets the addin do its thing while Session B would watch Session A for changes and run its code.
Can anyone think of potential issues with this solution? I've tested by created the two sessions, running (and pausing) code in 1 session while triggering an event in the other - and seems to work fine. Now, obviously, I won't be able to use an event in session 2 to capture the updating in session 1.. unless I use a class module to capture application level events in session 1.... ok, a few things to think about but - back to the question - anyone experienced and know of issues I need to be aware of?