DDEPoke

DDEPoke($variable,item,data[,onErrorLabel:])

Where:

$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 to be updated.

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

onErrorLabel:

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

The DDEPoke command sends text to a Dynamic Data Exchange (DDE) server application.

Example

DDEPoke($channel,"R1C1","some data")

Sample Script

' This script starts Microsoft Excel with a test spreadsheet.

' "some data" is then put into row 1 column 1 of the spreadsheet.

' The spreadsheet is saved and Excel is closed.

' The DDE conversation is terminated.

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

Wait(1000)

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

DDEPoke($channel,"R1C1","some data")

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

DDETerminate($channel)

exit