Excel DDE and Socket C#
 

Dear all,



I have the project which is mainly based on excel DDE and it is server and
client program.

In server, there is 1000 random numbers generating per second. It is not
excel based. It may be c sharp program acting as socket server.



In client, it is excel file with custom functions. If user type in the
formula in the cell e.g. getnumber("10"), it will get the current number 10
value in the server. It is hoped that the server and client data refresh in
real time.



I really don't know how DDE Excel apply in this case?? Would socket
programming apply in this case??

Do you have any instructions to teach me how to do??