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.