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