DDERequest

$return = DDERquest($variable,item[,onErrorLabel:])

Where:

$return

is a variable that receives the result of the request..

$variable

is the variable containing the DDE channel number. The DDE channel is established by the DDEInitiate command.

item	is the name of the item being requested.

onErrorLabel:

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

The DDERequest command receives text from a Dynamic Data Exchange (DDE) server application.

Example

$result = DDERequest($channel,"R1C1")

Sample Script

' This script starts Microsoft Excel with a test spreadsheet,

' gets the data in row 1 column 1 of the spreadsheet, terminates Excel,

' and types the requested text into the terminal emulation screen at

' the current cursor location.

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

Wait(1000)

$channel = DDEInitiate("EXCEL","Sheet2")

$result = DDERequest($channel,"R1C1")

DDEExecute($channel,"[QUIT()]")

DDETerminate($channel)

type($result)