DDE

DDE {POKE | REQUEST | EXECUTE},service,topic,item{,data | $result}[,onErrorLabel:]

Where:

POKE	sends text to the DDE server application.

REQUEST

requests text from the DDE server application.

EXECUTE

sends a command to the DDE server application.

service

is name of the DDE application for this conversion.

topic

is name of the DDE topic for this conversion.

item	is the name of the DDE item for this conversation.

data	is a string of text to be sent to the DDE server application for a POKE operation.

$result

is a variable that receives the result of a REQUEST operation.

onErrorLabel:

is a label that execution transfers to if an error occurs.

The DDE command is a shorthand command that performs a complete DDE conversation in a single command. It performs the functions of DDEInitiate, one of DDEPoke, DDERequest or DDEExecute, and DDETerminate. Use this command if you want to perform a single DDE function.

Examples

DDE REQUEST,"EXCEL","Sheet2",R1C1,$RESULT

Sample Script

* The following script starts Microsoft Excel with a test spreadsheet,

* gets the data in row 1 column 1 of the spreadsheet and types it into

* the terminal emulation screen at the current cursor location.

Run "C:\Program Files\Microsoft Office\Office11\excel.exe ""D:\Test.xls"""

Wait 1000

DDE REQUEST,"EXCEL","Sheet2",R1C1,$RESULT

type $RESULT

exit