Belajar PLC dan SCADA

Just another Blog about Programmable Logic Controller & SCADA.

Free SCADA – how to connect Excel to Allen Bradley CompactLogix PLC

Written by Kang Abu on 9:19 AM

If you have Microsoft Excel you can read and write data from Allen Bradley PLC ( CompactLogix or ControlLogix processor) using the DDE/OPC capabilities of RSLinx.
So how this free SCADA works?
In this example I am going to use Allen Bradley CompactLogix PLC 1769-L35E . I have RsLinx Classic ( no Lite – Lite edition does not support DDE ) and of course Microsoft Excel 2007.

First we need to open our RSLogix5000 project and create global tags (controller tags). I am going to use 2 tags from our last article about PLC Ladder Logic programming. Tags ORDER and TEMPERATURE have already some values. For testing purposes you can enter any values too.

They are arrays of 10. Create tags ORDER as DINT[10] and TEMPERATURE as REAL[10].
RSLogix tags

When tags are ready we have to open RSLinx software and create DDE/OPC topic. My PLC topic is OFFICE. Right click on your processor and select Configure New DDE/OPC Topic.

create RSLinx DDE

Remember you topic name (mine is OFFICE) as you need it later to enter in our VB code in Excel. Click apply and close the program. Open Excel and create Command Button. If you cannot find Command Button go to excel options and add it to your toolbar.

Together we need 2 buttons and table like on this picture below. Then right click on button and select View Code.

Enter now VB code for firs Read button.

Next is code for RSLinx communication

connect to RSlinx code

And finally Write button

Our free SCADA is ready to test now. Try to read values from PLC. Mine Excel table looks like this:

Related Posts by Categories

Widget by Hoctro | Jack Book
Related Posts with Thumbnails

Our Advertising

Bantuan Pencarian

Jika anda seorang pemula dan tertarik untuk belajar PLC silahkan cek artikel di arsip artikel atau gunakan bantuan pencarian artikel di bawah ini. TQ Bro..

Email Subscribe

Dapatkan informasi dan artikel yang update dari situs ini. Jika anda barminat silahkan masukan email address anda di bawah ini. Terimakasih! (Please write email to subscribe our news).

Enter your email address:

Delivered by FeedBurner

Disclaimer (Privacy Policy)

No PDF Files stored in this site. are not responsible if you download and distribute files or links. Noted that not related in any way with upload files with a copyright material that available for download. Just we collects the information using google search and other search engines links hosted or posted by other website. The link Free Book Download available here are for EDUCATIONAL PURPOSES ONLY... and its recommended to buy the products from the original Owner or Publisher.

For Detail Please Click Here!

Jika anda mempunyai artikel sepurtar dunia automation (PLC dan SCADA) dan ingin sharing buat teman-teman blogger silahkan kirim ke

Jika anda menginginkan semua berita yang ada disitus dan links yang ada di situs ini menjadi bagian dari situs yang anda punyai silahkan masukan address ini (copy & paste): di fungsi RSS Feeder situs anda.