Hello,
Just got a new computer and trying to get the real time API to work on excel. I followed the installation steps and tried the simplest code from tutorial but it yields me an error "Object variable or with block variable not set".
Below is my code:
Dim WithEvents myRTGet As AdfinXRtLib.AdxRtLi Sub myRtGetExample() Set myRTGet = CreateAdxRtList() With myRTGet .Source = "IDN" .RegisterItems "EUR=", "BID" .StartUpdates RT_MODE_IMAGE End With End Sub ' Returns the initial image for the instrument. NOTE - .StartUpdates RT_MODE_IMAGE' Private Sub myRtGet_OnImage(ByVal DataStatus As AdfinXRtLib.RT_DataStatus) ' The value for the specific instrument, specific field, only one in this case.' Debug.Print myRTGet.Value("EUR=", "BID") End Sub
Any idea what is happening ?
Thanks for the help!