connect excel to RSLogix 5000 project to read and write data

السلام عليكم

1.Start Excel software
2.in RSlinx software go to menu DDE/OPC-> Topic configuration








3.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
3.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

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

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

شكرا

السلام عليكم

How to write data from an Excel spreadsheet to a ControlLogix using RSLinx


1. Create a DDE Link to read from the ControlLogix processor (to see the download take place). In this example 10 cells from A1 through J1 were used to display the first ten elements of a two dimensional double integer array in ControlLogix processor..
2. Enter data in the cell or cells you wish to download (in this example, 10 cells from A2 through J2 were used).
3. Create a button to trigger the download. If you want to use something else to trigger the download, configure it in VBA.
4. Create a module with the following code and assign it to the button. Substitute your RSLinx topic name and source for the ones in the example. ("CTLGX" and "DblIntArray1[1,0],L10,C10")



وهذا رابط الموضوع

Follow this link
http://rapidshare.com/files/357587975/How_to_write_data_from_an_Excel_spreadsheet_to_a_ControlLogix_using_RSLinx.doc
or
http://narod.ru/disk/18379445000/How_to_write_data_from_an_Excel_spreadsheet_to_a_ControlLogix_using_RSLinx.doc.html
Size: 45 KB
Best regards


شكرا

السلام عليكم

الحمدالله اخي العزيز بصراحه كنت خائف جدا من احتمال اكون قد اخطاءت في شي او في الترتيب على الاقل والحمد لله على هذا الرضا

شكرا

السلام عليكم

لدينا نحن منظومه dcs تستخدم طريقه مقاربه لكن مع وحده yakogawa لطبع التقارير يصوره اليه

thank you very much ,like this we will ,the arabic counties will be stronger than ever before

there is problems in links,they appairs not work,jazakome allah khayrane someone upload those document