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.