This project is read-only.

NDDE Server with Excel 2010

Aug 25, 2014 at 2:42 PM
Hi all,

Using Excel 2010 as Client to exchange data with NDDE server results in a behavior I can't explain!
At First I thought I did something wrong in my own application so I switched to the NDDE server application which is included in the zip package as example.
I'm excuting the following code from Excel (VBA):

Sub DDE_Test()
  ' Dimension the variables.
  Dim Chan As Integer
  Dim RequestItems As Variant

  ' Start a channel to Word using the System topic.
  Chan = DDEInitiate("myapp", "simulation mode")

  DDEPoke Chan, "TestItem", Cells(1, 1)
  ' Requesting information from Word using the Formats item
  ' this will return a one dimensional array.
  RequestItems = DDERequest(Chan, "TestItem")

  ' Terminate the DDE channel.
  DDETerminate Chan
End Sub

Cells(1, 1) contains the string "Test".

At the Server side I'm receiving 17 bytes?
Decimal: 16, 0, 4, 0, 1, 0, 1, 0, 2, 0, 5, 0, 4, 84, 101, 115, 116.
The last four bytes represent the original message "Test" but what is the rest?
The format reported by the Server application is 49734?
Also when sending data back to Excel it seems the format isn't correct. I suppose this has to do with the same problem.

Using LabView or VeePro as Client is no problem! Sending "Test" as data is received by the server as "Test", thus without the extra preceding bytes!
This time the format reported by the Server application is 1.

Does anybody have a clue what is happening using Excel2010 as Client?