Using VBA to parse RTD objectdata
 

Hi,

I have a spreadsheet which uses the RTD method to get real time data
into my spreadsheet.

I'd like to use VBA to do some calculations on a large number of these
RTD values.

Is there a way I can use VBA to subscribe to, and parse, RTD data,
without having to insert the RTD function into an excel cell?

Thanks,

enter

Using VBA to parse RTD objectdata
 

You can use RTDdata = worksheetfunction.RTD(parameters). The parameters
would be the same as on a worksheet.

"Enter The" wrote:

Hi,

I have a spreadsheet which uses the RTD method to get real time data
into my spreadsheet.

I'd like to use VBA to do some calculations on a large number of these
RTD values.

Is there a way I can use VBA to subscribe to, and parse, RTD data,
without having to insert the RTD function into an excel cell?

Thanks,

enter

Using VBA to parse RTD objectdata
 

Thanks for the response Joel.

How can I catch the updates in the RTDdata object that is returned? I
assume it's some sort of update event. But I can't find any online
documentation on the subject.

Using VBA to parse RTD objectdata
 

Try this microsoft webpage

http://support.microsoft.com/kb/285339

"Enter The" wrote:

Thanks for the response Joel.

How can I catch the updates in the RTDdata object that is returned? I
assume it's some sort of update event. But I can't find any online
documentation on the subject.