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

RSLinx, RSLogix, RSView, LogixPro ...
Post Reply
JurgenG
Posts: 9
Joined: Sun Jul 13, 2008 10:26 am
Location: Europe

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

Post by JurgenG » Sun Jan 24, 2010 9:46 am

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
Posts: 104
Joined: Sat Jun 13, 2009 12:25 pm
Location: Europe

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

Post by dehell » Mon Jan 25, 2010 5:50 pm

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

dehell
Posts: 104
Joined: Sat Jun 13, 2009 12:25 pm
Location: Europe

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

Post by dehell » Mon Jan 25, 2010 6:26 pm

Hi
Follow this link for read tag with excel
best regards

http://rapidshare.com/files/340961837/Step1.pdf.html

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

Image

Step 2 -> create your DDE/LINK

Image

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

Image

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

Image

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

Image

Choose « paste with link » then click on OK

Image

dehell
Posts: 104
Joined: Sat Jun 13, 2009 12:25 pm
Location: Europe

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

Post by dehell » Tue Feb 23, 2010 9:06 pm

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

hoangnguyen1986
Posts: 33
Joined: Thu Mar 27, 2008 2:18 am
Location: Vietnam

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

Post by hoangnguyen1986 » Sat Feb 27, 2010 8:58 am

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

teppi80
Posts: 4
Joined: Thu Aug 20, 2009 3:32 pm

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

Post by teppi80 » Mon Mar 01, 2010 4:32 pm

@dehell: Could you please upload the files again?


teppi80
Posts: 4
Joined: Thu Aug 20, 2009 3:32 pm

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

Post by teppi80 » Tue Mar 02, 2010 9:12 am

Thank dehell.

cuongvcs
Posts: 140
Joined: Fri May 23, 2008 4:00 pm
Location: Vietnam

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

Post by cuongvcs » Tue Jun 15, 2010 1:51 am

Thank for your help.

kucluk
Posts: 1
Joined: Mon Jun 21, 2010 1:03 am

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

Post by kucluk » Mon Jun 21, 2010 1:13 am

thanks bro..nice info.. (pgood)

JurgenG
Posts: 9
Joined: Sun Jul 13, 2008 10:26 am
Location: Europe

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

Post by JurgenG » Thu Sep 23, 2010 11:52 am

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
Posts: 104
Joined: Sat Jun 13, 2009 12:25 pm
Location: Europe

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

Post by dehell » Fri Sep 24, 2010 4:47 pm

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

Martin
Posts: 2
Joined: Fri Mar 18, 2011 2:29 pm

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

Post by Martin » Fri Mar 18, 2011 2:40 pm

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
Posts: 70
Joined: Fri Oct 15, 2010 9:18 pm

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

Post by neuhauser » Wed Mar 23, 2011 4:44 pm

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

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

Martin
Posts: 2
Joined: Fri Mar 18, 2011 2:29 pm

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

Post by Martin » Sun Mar 27, 2011 8:47 pm

Thanks

Post Reply