View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
S Guy S Guy is offline
external usenet poster
 
Posts: 3
Default excel focus problems with custom RTD server (real time data)

I have a worksheet with RTD formulas in it. When the real time data
changes, excel grabs focus. (ie. excel pops itself to the front) How
do I stop excel from grabbing focus?

I've seen a couple of posts that seem related, but I haven't found any
solutions:

http://groups.google.com/groups?hl=e...bl%26rnum%3D14

http://groups.google.com/groups?q=ex...TNGXA11&rnum=1


I've also run many tests and found some odd behavior:

If I create an excel workbook with only formulas that use the
bloomberg.rtd server, things seem fine (excel does not grab focus). I
can have hundreds of these formulas and dependent formulas, etc.

If I create an excel workbook that contains references to the rtd
server that I have written (in VC++), excel grabs focus when these
values change.

I have looked through the code for my RTD server very carefully, but I
can't seem to find any problems with it. It provides data to excel
through the standard RTD interface -- data comes in, I store it in a
set, I call UpdateNotify(), when excel has some spare cycles it calls
be back with RefreshData() and I give it the data in my set.

Any help / insight / workarounds would be appreciated.

BTW, I am using WindowsXP / Excel2002.

Thanks,
steven