ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   RTD only alive when Excel is active app? (https://www.excelbanter.com/excel-programming/396892-rtd-only-alive-when-excel-active-app.html)

[email protected]

RTD only alive when Excel is active app?
 
Hello

I have an RTD server that I wrote that seems to work OK when used by
itself, however, when Excel is not the active application, the
interaction does not work.

Specifically I am calling UpdateNotify informing Excel that I have
data for it,
but I don't get called until Excel is Active (i.e. on-top and focus-
in) again.

Is this expected / intended, or is my RTD likely not playing well with
others?

The end-user has their ThrottleInterval turned down, so that updates
are more frequent. Might it cause a problem if the ThrottleInterval
is too low?

Can Excel end up in such a state that it is too 'busy' to respond to
RTD, until it somehow gets tickled by activating it (by clicking on
it?)

Further background:
The excel sheet in question is a 'busy' one. With two other RTD
servers loaded for financial information, and extensive use of macros
for various functions.

Many Thanks
sdg



All times are GMT +1. The time now is 10:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com