DDE Sample (task)
Demonstrates DDE Execute, DDE Poke and DDE Request
The attached task demonstrates DDE Execute, DDE Poke and DDE Request. The task assumes that Excel is running with a worksheet named Sheet1.
DDE Execute: Maximizes the Excel spreadsheet.
DDE Poke: Will write the number 7 in row 1 column 1 of Sheet1.
DDE Request: Will grab the value from row 1 column 1 of Sheet1 and populate variable varTest.