Datalogging into Excel using DDE/OPC

[pfleck 0]

Has anyone written code to datalog directly into excel. I can transfer data from the processor (utilizing DDE) to a cell, but I would like to increment the cell for each subsequent data point. I would assume that I would have to use VBA to increment the cell, but I am pretty green when it comes to that. ie. Temperature Time(HH:MM:SS) 1020 13:01:55 1022 13:02:57 1021 13:03:56 . . . Thanks in Advance, Phil

[Chris Elston 78]

Yup. Download this: http://forums.mrplc.com/index.php?act=Downl...&CODE=02&id=134 Other documents here. http://forums.mrplc.com/index.php?act=Downl...&CODE=01&cat=38 Open up the sheet in Excel and edit the macro. Hopefully by looking at the code you can see what you need to do. Also, make sure you have a full version of RS Linux to do DDE requests.

[panic mode 246]

RS Linux? Somebody was working long hours on server...

[Chris Elston 78]

Oh crap...Sorry about that. I got Linux on the brain...Your right. That should be: RS LINX DOH....

[Snerkel 0]

I wrote this many moons ago, but it does roughly what you want Starbottom_040901.zip