Page 1 of 1
[?]: I want to connect excel to my RSLogix 5000 project
Posted: Sun Jan 24, 2010 9:46 am
by 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
Re: [?]:I want to connect excel to my RSLogix 5000 project
Posted: Mon Jan 25, 2010 5:50 pm
by dehell
Hi
I am not sure but i think you can't write data with Excel : only read is possible.
Best regard
Re: [?]:I want to connect excel to my RSLogix 5000 project
Posted: Mon Jan 25, 2010 6:26 pm
by dehell
Hi
Follow this link for read tag with excel
best regards
Link_is_Dead :(/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
Re: [?]:I want to connect excel to my RSLogix 5000 project
Posted: Tue Feb 23, 2010 9:06 pm
by dehell
Hi,
It is possible to write data from excel to Contrologix PLC
Follow this link
Link_is_Dead :(/H ... RSLinx.doc
or
http://narod.ru/disk/18379445000/How_to ... x.doc.html
Size: 45 KB
Best regards
Re: [?]:I want to connect excel to my RSLogix 5000 project
Posted: Sat Feb 27, 2010 8:58 am
by hoangnguyen1986
oh Thank so much for your instruction! I'm really appreciate about that. I tried and i did it without any problem
Thanks!!!
Re: [?]:I want to connect excel to my RSLogix 5000 project
Posted: Mon Mar 01, 2010 4:32 pm
by teppi80
@dehell: Could you please upload the files again?
Re: [?]:I want to connect excel to my RSLogix 5000 project
Posted: Mon Mar 01, 2010 8:20 pm
by dehell
Re: [?]:I want to connect excel to my RSLogix 5000 project
Posted: Tue Mar 02, 2010 9:12 am
by teppi80
Thank dehell.
Re: [?]:I want to connect excel to my RSLogix 5000 project
Posted: Tue Jun 15, 2010 1:51 am
by cuongvcs
Thank for your help.
Re: [?]:I want to connect excel to my RSLogix 5000 project
Posted: Mon Jun 21, 2010 1:13 am
by kucluk
thanks bro..nice info..
Re: [?]:I want to connect excel to my RSLogix 5000 project
Posted: Thu Sep 23, 2010 11:52 am
by 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.
Re: [?]:I want to connect excel to my RSLogix 5000 project
Posted: Fri Sep 24, 2010 4:47 pm
by dehell
Hi,
You have to create a Excel macro.
Follow this link:
http://narod.ru/disk/18379445000/How_to ... x.doc.html
Best regard
Re: [?]: I want to connect excel to my RSLogix 5000 project
Posted: Fri Mar 18, 2011 2:40 pm
by 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?
Re: [?]: I want to connect excel to my RSLogix 5000 project
Posted: Wed Mar 23, 2011 4:44 pm
by neuhauser
Here is a link to a forum discussion using DDE in calc.
http://www.oooforum.org/forum/viewtopic.phtml?t=39364
Re: [?]: I want to connect excel to my RSLogix 5000 project
Posted: Sun Mar 27, 2011 8:47 pm
by Martin
Thanks