When you perform a large number of DDE POKE requests from an application such as Microsoft Excel, the DDE server application may fall behind. Under Excel, this will cause some requests to timeout and fail.
To avoid this condition, insert delays in your setpoint macros as follows:
ManyPoints
channel=INITIATE("cwserv","point")
=POKE(channel,"point001.value",Sheet1!D4)
=POKE(channel,"point002.value",Sheet1!D5)
=POKE(channel,"point003.value",Sheet1!D6)
=POKE(channel,"point004.value",Sheet1!D7)
=WAIT(NOW() + "00:00:01")
=POKE(channel,"point005.value",Sheet1!E4)
=POKE(channel,"point006.value",Sheet1!E5)
=POKE(channel,"point007.value",Sheet1!E6)
=POKE(channel,"point008.value",Sheet1!E7)
=WAIT(NOW() + "00:00:01")
=POKE(channel,"point009.value",Sheet1!F4)
=POKE(channel,"point010.value",Sheet1!F5)
=POKE(channel,"point011.value",Sheet1!F6)
=POKE(channel,"point012.value",Sheet1!F7)
=TERMINATE(channel)
=RETURN()
Depending on the performance and configuration of your computer, your delay requirements may vary.
|
|
3. Modify point data. |
