Rslinx using DDE to Excel file

teal845t · Jan 11, 2006

I like to know how to use Rslinx with DDE to excel file. I like to monitor i/o using excel.
I want to monitor machine start, stop and faults with date and time on excel.
What processor do I need? I don't know how to set up DDE. I read rslinx help instruction and still did not get it.
Thanks

Oakley · Jan 11, 2006

I set up a DDE topic in RSLinx.

Then in excel, I place the following formula:
=RSLINX|'DDE'!'Tagname'
Where DDE is the topic name set up in RSLinx and Tagname is the address in which you want to watch.

I am using this to watch tags from a Allen Bradley ControlLogix processor.

OkiePC · Jan 11, 2006

First, you must have a version of RSLinx that supports DDE. RSLinx Lite will NOT do it.

Then, set up your RSLinx communication drivers so that you can see the processor(s) to be polled in RSWho. From there, follow the instructions in the attached file. It's a step by step cheat sheet I made up from excerpts of RSLinx help.

I hope this gets you going ...

teal845t · Jan 11, 2006

Can I use Micrologix 1000 or Slc501?

teal845t · Jan 11, 2006

Can I use Micrologix 1000 or SLC 5/01?

Thomas Sullens · Jan 11, 2006

teal845t · Jan 12, 2006

OkiePC, I tried your instruction. I can't find Edit>Copy for step 3 of 4. I have rslinx 2.31.00, I'm using micrologix 1000 just to try.

OkiePC · Jan 12, 2006

From the main menu in RSLinx:

I'm using Gateway version 2.43.
If you're using RSLinx Lite, this feature is unavailable.

Rslinx using DDE to Excel file

teal845t

Member

Oakley

Member

OkiePC

Lifetime Supporting Member

teal845t

Member

teal845t

Member

Thomas Sullens

Member

teal845t

Member

OkiePC

Lifetime Supporting Member

Similar Topics