Questions about using DDE with Excel

Forum for discussing PicoLog
Post Reply
erkme73

Questions about using DDE with Excel

Post by erkme73 »

I am currently montioring pressure changes (via ADC-11 & Picolog). I have tried the =PLW|current|value command in Excel, and it DOES work.

However, I would like to have a cell within Excel that does a real time calculation to determine the rate of change.

For example, the current cell (A1) changes every second. I'd like a neighboring cell (B1) to be able to take the current A1 value and subtract it from the previous A1 value - thus giving me a real-time, per second rate of increase/decrease.

Is there anyway to perform this using Excel? I know I can do it from a saved table, but that's not real time. Any suggestions would be very much welcome!!

Another question relating to DDE - is it possible to specify which channel is the "current" value? I have three channels, and would like all three in the Excel sheet. Can this be done as well.

Thanks!!

Eric

User avatar
markspencer
Site Admin
Site Admin
Posts: 598
Joined: Wed May 07, 2003 9:45 am

Post by markspencer »

Hi,

I am unable to answer the question pertaining to calculations in real time, I would suggest getting a good book on excel, or looking at microsofts website. Alternatively, may be someone else on the forum could explain how to do this.

Unfortunately, it is not possible to specify the channel using DDE. To do this you would need to write a macro (VBA). We provide a simple example on how to do this, and it also may make the above (real time calculation) easier as well.

Best regards,
Regards,

Mark Spencer

Post Reply