RTD function in Access

[agibsonsw]

Hello. Access 2003

Excel has an RTD function to obtain real-time data from a server. Is this function then available to Access via Automation? That is, if I add a reference to the Excel Object Library,
would myXl.WorksheetFunction.rtd(..) work?
Thanks, Andy.

[HansV]

If myXL is an object of type Excel.Application that you have created, you should be able to use

myXl.WorksheetFunction.RTD(...)

or even

myXL.RTD(...)

[agibsonsw]

Thank you.