Hi,
I'm working in a bank and, when we ran under Windows NT 4. we used Excel 97.
When we want to run some realtime Application, we used some activeX to notify Excel to Say Something is appening in the market.

Like That !
we realised an activex in C++

VBA Code :

dim myNotifyer as SpyMarket

public sub startSpy ()
myNotifyer.StartSpy
end sub

' my callBack
private myNotifyer_ItemChange (byVal idOfItem)
'here we launch some method, to check value on market
'and we send some orders in the market
end

Today, this application run perfectly under Excel 97
But when i try to use it under Excel 2002, i had some problems.

1) when i launch myapplication and do anything with Excel, it's Work
2) When i launch my application and i try to edit a Rangen, uUUUUHHHHH, some Error Appears


Any Idea.

So i Read Document About RTD, but it's not very clear.

Excuse me for my English.