Question on DDE link to Excel.

[jgr]

I have the system reading real time values into Excel.

Is there a way in Excel to have it execute a function on the change of value coming in from esignal. Say, every time the Tick count increase, have Excel then add the current Last value to a running total.

Thanks for any help here.

jgr

[Adina]

from my limited experience, you would need a function in excel turned on that checks every say 5 secs or 1 min or whatever to run something to see if its changed. Otherwise muck around with the VBA modules for a spreadsheet that look at changes occuring in a spreadsheet.
Alternatively if its only a running total, every day you start the system start the counter at one, and then add the tick count value to it.
(hope something helps)

[sellhighbuylow]

What's wrong you don't like all those pretty zeros? Lol
I've been there and its a headache! You need some vba.
If you don't know how to write it then you should try a search engine with the words excel help forum.
There are a few forums with excel experts. You'll get help faster if you ask the question in simple terms. You will have problems if you try to run too many workbooks with that vba, that is if your computer isn't up to par.