Receiving Data from an Application


The DDEREQUEST function returns a string containing the value of a specific data item. In the above example, the DADiSP variable aval is set to the value of cell A1. Of course aval can be converted into numeric form with:


aval = numstr(aval)


An entire data series can be retrieved with DDEGETDATA. For example,


ddegetdata(chan, "R1C1:R100C1")


retrieves all the data from row 1 column 1 to row 100 column 1 in a series and places the series in the current Window.


ddedata = ddegetdata(chan, "R1C1:R100C1")


retrieves the data and assigns the data to the variable ddedata.