I have developed the Real time data server using VB and using in Excel via RTD function.
When i write the following function its working fine. It return the value from Refresh Data function of "IRTDServer" interface provided by Excel.
=RTD("EXcelRTD.rtdfunction",,A11,"ASKPRICE")
Now the problem I need to pass an array (Multi values on one event) and then how to handle that in excel so that i can manuplate the value in the xl (How to show the multi values from array) in multiple cell.
Thanks
When i write the following function its working fine. It return the value from Refresh Data function of "IRTDServer" interface provided by Excel.
=RTD("EXcelRTD.rtdfunction",,A11,"ASKPRICE")
Now the problem I need to pass an array (Multi values on one event) and then how to handle that in excel so that i can manuplate the value in the xl (How to show the multi values from array) in multiple cell.
Thanks