[?]: I want to connect excel to my RSLogix 5000 project

[JurgenG]

Hi,

I have a litle problem.
I want to connect excel to my RSLogix 5000 project to read and write data!
I have no manuel to try this out!
Can sombody upload a manuel or link where it is explane step by step!

THANX

[dehell]

Hi
I am not sure but i think you can't write data with Excel : only read is possible.
Best regard

[dehell]

Hi
Follow this link for read tag with excel
best regards

http://plcforum.uz.ua//Step1.pdf.html

Step 0 -> Start Excel software
Step1 -> in RSlinx software go to menu DDE/OPC-> Topic configuration



Step 2 -> create your DDE/LINK



Click on New
Then give a name to this new link : for example : emulator
Then give the path to the online PLC
Click on Apply : your DDE/OPC link have been created
Click on Done.

Step3-> Goto Menu Edit-> Copy DDE/OPC Link



Then choose your DDE/OPC Link : Emulator->Online



Choose the tag you need : for exemple Test_Tag
Then click on OK

Step 4-> Paste link in Excel
In Excel software
Choose a cell and then using the right button of your mouse click on special paste



Choose « paste with link » then click on OK

[dehell]

Hi,
It is possible to write data from excel to Contrologix PLC
Follow this link
http://plcforum.uz.ua//H ... RSLinx.doc
or
http://narod.ru/disk/18379445000/How_to ... x.doc.html
Size: 45 KB
Best regards

[hoangnguyen1986]

oh Thank so much for your instruction! I'm really appreciate about that. I tried and i did it without any problem
Thanks!!!

[teppi80]

@dehell: Could you please upload the files again?

[dehell]

Link
http://plcforum.uz.ua//H ... RSLinx.doc
or
http://narod.ru/disk/18379445000/How_to ... x.doc.html
Size: 45 KB
Best regards

[teppi80]

Thank dehell.

[cuongvcs]

Thank for your help.

[kucluk]

thanks bro..nice info..

[JurgenG]

Hello,

Read data from a Rslogix5000 project to excel works fine!
But i will try to send a preset value for a timer from excel to rslogix.
Example: 5000 to Timer_1.
How can i do that?


best regards

J.

[dehell]

Hi,
You have to create a Excel macro.
Follow this link:
http://narod.ru/disk/18379445000/How_to ... x.doc.html
Best regard

[Martin]

Hi,

Sending data from Excel to RsLogix works fine!
I'm trying to do the same with use of Open Office Calc. Obviously macros from Excel do not work.
Does anyone know how to prepare equivalent macros for Open Office calc?

[neuhauser]

Here is a link to a forum discussion using DDE in calc.

http://www.oooforum.org/forum/viewtopic.phtml?t=39364

[Martin]

Thanks