DDE

DDE({POKE | EXECUTE},service,topic,item[,data][,onErrorLabel:])

$return = DDE(REQUEST,service,topic,item[,onErrorLabel:])

Where:

$return

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

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 conversation.

topic

is name of the DDE topic for this conversation.

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.

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

$result = DDE(REQUEST,"EXCEL","Sheet2",R1C1)

Sample Script

' This 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)

$result = DDE(REQUEST,"EXCEL","Sheet2",R1C1)

type($result)

exit