Questions about using DDE with Excel

 
Post new topic   Reply to topic    Pico Technology Forum Index -> PicoLog
Author Message
erkme73
Guest
PostPosted: Tue Aug 26, 2003 2:30 pm    Post subject: Questions about using DDE with Excel Reply with quote
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
Back to top
markspencer
Site Admin
Site Admin


Joined: 07 May 2003
Posts: 610

PostPosted: Wed Aug 27, 2003 7:25 am    Post subject: Reply with quote
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,
Back to top
Display posts from previous:   
Post new topic   Reply to topic    Pico Technology Forum Index -> PicoLog
All times are GMT
Page 1 of 1

 


Pico Technology topic RSS feed 
Powered by phpBB © 2001, 2005 phpBB Group