I need to call a value from a RTD server which outputs data once a second and I need to pick up this data in vba then do lots of calculations on it and in some cases output data back to the same device which generates the RTD server.
The problem I am having is actualy with the first bit of just geting the data into vba i can type = RTD("name of server",,"channel name") in to a cell and i get the value which updates and works perfectly. but pulling this in to vba and then in to an array to do loads of calcuations when this is being pulled once per second it makes no sense and really slows down much of my program
I really want to put this straight in to vba so i have tried numerous options based around the following:
variable = Application.WorksheetFunct
ame of server","","channel id")
I have tried several different versions of this inlcuding null string in stead of the "" and many different alternatives which are very similar. None seem to work all give me error messages
Unable to get the RTD Property of the worksheetfunction Class
I have looked through the forums on experts-exchange and found redmondb 's response,
to a similar question used the same code as he had and got the same response the only changes i made was that i inputed the name of my rtd server and channel number (or topic)
I have attached the file that contains the basic code that there seems to be a problem with.
Thanks in advance