How do I make DDE Server updating Excel clients?

Question

0.00/5 (No votes)

See more:

I’m Implementing DDE Server for Excel Clients to provide them with stock market real time data.
I used Ndde.Dll and created a class that inherits from NddeServer where I override the following methods and events

C#

OnBeforeConnect()
OnAfterConnect()
OnDisconnect()
OnStartAdvise()
OnStopAdvise()
OnExecute()
OnPoke()
OnRequest()
OnAdvise()
Advise()

- When application starts up I register the server and then when there is any updates I call the serverObj.Advice(Topic, Item). e.g serverObj.Advice(“Topic”, “item~Id”).

- Client select some data from data grid view he needs and copy them then opens excel sheet and paste the selected data items

- The formula of each cell looks like ‘ServerName|TopicName!’ItemName~Id’.

Issue is when data items updated in system they didn’t in Excel sheet 
- Could you help me, how can I fix this???
- Is there alternative methods for using DDE or missed steps to do??

Posted 22-Dec-14 2:10am

HassanShehata

Add a Solution

Comments

Maciej Los 22-Dec-14 8:58am

DDE is very old technology. Why to use this?
On the other hand, does server is online?
Have a look here: DDEApp Tutorial (C#, C++)[^]

HassanShehata 23-Dec-14 6:29am

It's required to share some real time data with Excel Clients and that was existing architecture which required to fix and run it, but what are the best other methods to do so??

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2014-12-22T03:02:00

Solution 1

Please, read my comment to the question.

Please, refer this: Dde Excel Client On Another Computer Cannot Connect To Dde Server[^]

Posted 22-Dec-14 3:02am

Maciej Los

Comments

HassanShehata 23-Dec-14 3:14am

Thanks #Maciej,
My DDE Server and Excel Client are in the same machine.
the server is registered and connect successfully to client and sends initial data fine but the issue in specific occurs when update occurs and server transmits message by it, excel not updated with new value.
could you provide me with the way you advice excel client by new updates?? I think that may be more helpful...
With best regards.

Maciej Los 23-Dec-14 3:27am

Sorry, i'm not familiar with DDE as i wish ;(

HassanShehata 23-Dec-14 6:30am

Do not worry, Thanks so much for your effort :)

Maciej Los 23-Dec-14 6:32am

;)