DDE Troubleshooting

[Opterabot22]

I've been trying to create a connection between Excel and a terminal
program that supports several DDE commands. I can initialize the
connection, read information from it, but when I try a Poke command it
fails. I'm running Excel 2000 PRO under Windows 2000. Any
suggestions on how I can troubleshoot this? I thought it might by the
symantic anti-virus program, but when I shut down the two services it
had no effect. The DDE connection works under 98 and XP at home, so
I'm assuming it's an OS issue (unlikly), or some other service that it
getting in the way. Any thoughts would be appreciated.

Corey

 

[letsride]

dde poke Description Inserts designated value(s) into
specified location in server program. Syntax dde poke
convId item value convId Specifies the returned value
from the dde initiate command. Item Specifies the string
containing the item ID that a change in value is
requested. value Specifies the string containing the
desired value. Returns Returns an empty string. Example
Pokes the three numbers to three cells in TEST.XLS. for
{i = 1}{$i < 4}{incr i}{dde poke $conv R1C$i $cel($i)}

 

[pgerrish]

I believe that the Poke statement requires Excel to act as a DDE
Server. This is different than how DDE is usually used where DDE
informtion is read into excel (Excel as a DDE Client).

under Win NT 4.0: I have been able to get excel to act as a DDE server
, both locally and under NetDDE.
under Win 2k : I have been able to get excel to act as a server
locally.
under Win 2k : I have been unable to get Excel to work as a server
over NETDDE.

It probably is an OS issue. As microsoft no longer supports DDE -
your best bet is to find an OS that works and stick with it.