800-222-0550 / 732-287-2100

Here is an example of PowerTerm as a DDE client, using the DDE.PSL script which is included in the PowerTerm program.

1. On your PC, start an Excel spreadsheet, and input the following formula into R2C1:
   • =SUM(A1:C1)
   • Save this sheet as TEST.
   • Minimize the Excel program.
2. Connect to your host with PowerTerm.
3. Compose a screen on the host which has 3 numbers on rows 4, 5, 6 in columns 10-15.
4. Start a program on the host, such as vi which will accept input.
5. From PowerTerm, run the DDE.PSL script (Script | Run Script)
6. Choose DDE from the list of available script, and Press Open.

This illustrates the use of PowerTerm as a DDE client.

• conv = [dde initiate EXCEL TEST.XLS] This opens the DDE channel between PowerTerm and the Excel program (which must already be running.) Windows gives this channel an ID number, which PowerTerm stores in the conv variable.
• dde poke $conv R1C$i $cel($i) This uses the channel stored by the $conv variable and places into the sheet [with the DDE poke command] in cell R1C$i [we are in a PowerTerm for loop] the value we stored earlier in as the array element, cel($i).
• sum = [dde request $conv "R1C2"] This gets the value stored in R1C2 [with the DDE request command] and stores it in the sum variable.
• dde terminate $conv This closes the DDE channel.