[?]: I want to connect excel to my RSLogix 5000 project
[?]: I want to connect excel to my RSLogix 5000 project
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
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
Hi
I am not sure but i think you can't write data with Excel : only read is possible.
Best regard
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
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
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
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
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
-
- Posts: 33
- Joined: Thu Mar 27, 2008 2:18 am
- Location: Vietnam
- Contact:
Re: [?]:I want to connect excel to my RSLogix 5000 project
oh Thank so much for your instruction! I'm really appreciate about that. I tried and i did it without any problem
Thanks!!!
Thanks!!!
Re: [?]:I want to connect excel to my RSLogix 5000 project
@dehell: Could you please upload the files again?
Re: [?]:I want to connect excel to my RSLogix 5000 project
Thank for your help.
Re: [?]:I want to connect excel to my RSLogix 5000 project
thanks bro..nice info..
Re: [?]:I want to connect excel to my RSLogix 5000 project
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.
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
Hi,
You have to create a Excel macro.
Follow this link:
http://narod.ru/disk/18379445000/How_to ... x.doc.html
Best regard
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
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?
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
Here is a link to a forum discussion using DDE in calc.
http://www.oooforum.org/forum/viewtopic.phtml?t=39364
http://www.oooforum.org/forum/viewtopic.phtml?t=39364