RSLinx to Excel

93lt1

Member
Join Date
Apr 2002
Location
Mount Pleasant, Iowa
Posts
994
Where is a good place to get information about linking data from RSLinx (DDE) to Excel? The RSLinx help files are pretty good but I want more information about how Excel deals with this data....such as update times and the like.

Thanks in advance!
 
If you go to the AB.com knowledgebase and type in dde and excel it brings up a lot of tech notes.

also they put some good examples on the RSTrainer2000 for RSLinx training CD-ROM but that cost $$$$
 
I've used HOT links and COLD links before.

One application I had, I updated 15 words of information every 4 seconds. And it was hanging in there pretty good. I won't try and run a whole operator interface from EXCEL, which you can and I have done before on little machines that had Office and RSLINX installed instead of purchasing a panelview, I put FORM buttons in EXCEL to manual toggle outputs and stuff using DDE....

...but if you need SPEED, you should stick with OPC.

If you want to see an example of DDE and EXCEL. One can be downloaded here:

http://www.mrplc.com/cgi-bin/code/filedisplay.cgi?category=excel

Good Luck,
 
With Excel and DDE from RSLinx, the update time is defined by the Polling Topic field when you create the DDE Topic.

In RSLinx, go into DDE/OPC -> Topic Configuration -> Data Collection tab. 1000 milliseconds is the default, but even with a point-to-point DF1 connection you should be able to crank that up to 100 ms or so.

Network throughput depends on a multitude of factors, of course, so just turn up the updates to where you think they need to be to get good "responsiveness" from your spreadsheet application.
 

Similar Topics

Hi, I'm brand new to the forum and spent some time looking around but could not find an answer to my question. I'm using an excel spreadsheet to...
Replies
3
Views
1,325
Hello! I am trying to help a coworker get access to a company dashboard. It runs on my computer and I have set up similar dashboards myself, so...
Replies
4
Views
2,469
Hello All, I know it is possibile to access data from a PLC directly to excel using a OPC link through RSLinx...
Replies
2
Views
1,710
I use dde/OPC to read tag vaule in excel file its working ok when rslinx running NOT as service but when I run rslinx as service I got an error at...
Replies
5
Views
1,902
Sorry if this is off topic, but this is more of a VBA question. I have some data that needs to be collected weekly. I have an excel sheet so that...
Replies
6
Views
2,058
Back
Top Bottom