DDELINK

The service name (for example, excel) to create a DDE link with.

The topic within service with which to link. For most applications, the topic is a filename. Type the full path and filename of the wanted topic (for example, c:\stock\prices\05jan.xls).

items

The items in topic to link with. The syntax of the items depends on the selected service. For example, in Excel, R1C1:R10C20 selects rows 1-10 and columns 1-20.

Description

DDELINK creates a Dynamic Data Exchange (DDE) link with data in an external Windows™ application. It returns the number of columns specified in the items parameter. Changes in the source application will automatically be reflected in the IBM® PredictiveInsight spreadsheet.

Examples

TEMP = DDELINK(Excel, c:\excel\data.xls, C1:C2)

Creates two new columns named TEMP and VX, containing the values in columns 1-2 of the c:\excel\data.xls spreadsheet.

TEMP = DDELINK(Excel, c:\excel\data.xls, R1:R10)

Creates as many new columns as needed to accommodate rows 1-10 of the c:\excel\data.xls spreadsheet.

TEMP = DDELINK(Excel, c:\excel\data.xls, R1C1:R100C3)

Creates three new columns named TEMP, VX and VY containing rows 1-100 of the c:\excel\data.xls spreadsheet.

TEMP = DDELINK(123W, c:\lotsuite\sample.wk4, A:A1..A:C8)

Creates three new columns named TEMP, VX and VY containing rows 1-8 of columns A-C of spreadsheet A in the Lotus® file sample.wk4.

Related Functions

Function	Description
DATALINK	Creates an internal link to data in a IBM® PredictiveInsight spreadsheet