Excel xp RTD Function Dataset question?

[Marion Pope]

Is it possible to pass an array of data through a topic in
the RTD function? I would like to pass a dataset or array
from a .net RTD Server and fill in the spreadsheet by
putting an RTD function in the A1 column, similarly as can
be done through ADO in VBA from a macro, and popluate the
sheet from addressing one cell.

The dataset would be queried from the VB.net side from
parameters passed as topics from the RTD Function in Excel.

I have sucessfully developed the example in "Building
Excel Real-Time Data Components in Visual Basic .NET" from
Microsoft.

Any help will be greatly appreciated.

 

[Alexandre Nikolov]

Not directly. You need to write a macro that converts the returned value from RTD into array and than assign it to a range of cells. There is an example in MSDN: "Microsoft Knowledge Base Article - 286258: INFO: Excel RTD Finction cannot return an Array"