Using VBA to parse RTD objectdata

E

Enter The

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
 
J

Joel

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

Enter The

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top