Problems using RTD (real time data) function from VBA

[Valeria80]

Hi,

I am triying to use real time values from VBA, so I type:

WorksheetFunction.RTD("RTDEngine", "",BLJun - 9, "T") which works perfectly well from excel, but I can't access the value from VBA.


Can you please help me to sort this out?

Many thanks,

Valeria

[Stefan74]

Hi Valeria,
the RTD technology cannot update Excel cells while a macro is running. The only solution I know is a time triggered subroutine call via Application.onTime

Hope that helps.