PLC data to excel

If I was wanting to take data such as downtime and reasons for downtime from a plc (control logix) and transfer it to a spread sheet such as excel what would be reguired? Would i have to do any other programming than in ladder logic. And if so would it get really complicated

Here are a few things to look at:
http://domino.automation.rockwell.com/applications/kb/RAKB.nsf/0/DF3AA7885AAF615B85256AFB00678077?OpenDocument

http://domino.automation.rockwell.com/applications/kb/RAKB.nsf/0/C346E730DFFFB25E85256AFB0052526E?OpenDocument


http://domino.automation.rockwell.c...30A99E4A3CD5BA5185256B7B0056BB00?OpenDocument

http://domino.automation.rockwell.c...0FC608E65459D7FC85256AFB0067C102?OpenDocument

Another source will be RSLinx menu and help files, also somewhere in your Rockwell software menu will be the OPC information.

thanks alot, I forgot all about these little tutorials. I have found pretty much everything i need

rsdoran said:

Here are a few things to look at:
http://domino.automation.rockwell.com/applications/kb/RAKB.nsf/0/DF3AA7885AAF615B85256AFB00678077?OpenDocument

http://domino.automation.rockwell.com/applications/kb/RAKB.nsf/0/C346E730DFFFB25E85256AFB0052526E?OpenDocument


http://domino.automation.rockwell.c...30A99E4A3CD5BA5185256B7B0056BB00?OpenDocument

http://domino.automation.rockwell.c...0FC608E65459D7FC85256AFB0067C102?OpenDocument

Another source will be RSLinx menu and help files, also somewhere in your Rockwell software menu will be the OPC information.

Click to expand...

Ron
Could this be done the same way with RSLogix 500?

Yes, the only thing I have done it with is an SLC 500. I think the only real difference is the way tags are done, dont take my word for that tho I havent worked with the 5000.

If working with RSLogix 500 and RSLinx look in the help files, also somwhere in your Rockwell software listing should be OPCTools. Kim Gold also posted a way to setup DDE to excel for the slc on this site but I cant find that link/thread. I have it printed at work so will see if I can scan it and post it.

I think Chakorules also has an example download at http://www.mrplc.com

You can always goto the AB support KnowledgeBase and use DDE or OPC as the keyword and get even more info.

Edited ADDITIONS
I looked again for that Kim Gold post and couldnt find it specifically but this is one you may want to look at, always thought I had RSLinx lite and it the DDE/OPC tools were available with it but now I am not sure, you may need a pro version of RSLinx, check these threads too.

http://www.plctalk.net/qanda/showthread.php?s=&threadid=31&highlight=DDE

http://www.plctalk.net/qanda/showthread.php?s=&threadid=221&highlight=DDE

I think Chakorules also has an example download at http://www.mrplc.com

Click to expand...

Yeah there are a few examples posted by the guru's of plcs.net at mrplc. I did one myself you can download here:

http://www.mrplc.com/dl/index.php?action=view&view=entry&entryid=74

There is even some VB to DDE examples that a few other people in here have done that upload to the archive. Use the "search" feature in download code section and search for "DDE". Hopefully you'll be able to see and find what you need.

You know how to look at the VBA code in excel right? Go to Tools>Macros>Visual Basic Editor. Then click on Module1 to see the DDE VBA code. Make sure you have RS LINX running and a DDE topic created.