Posted 14 Aug 2014 Is there way to write a VB script that can write an Excel table into a 2D array for RsLogix 5000? I have looked around for proven examples, but so far have come up unsuccessful. Share this post Link to post Share on other sites
Posted 15 Aug 2014 Most of the download examples for Excel to RSlogix write a single cell to a single tag. They look sommething like Cell{a1} --> RSLinx {Topic Processor} TagData1. Now assuming your table data resides in cells A1 thru L20 you would need a pair of nested loops one for looping 1 thru 20 and the other for looping A thru L. Your Data Moves then become something like RSlinx {Topic Processor} TagData {ROW , COLUMN} where ROW == sreadsheet row {1-20} and then COLUMN == spreadsheet column A/1 thu L/12. IF for some reason that doesn't work then you'll send just Four tags over from Excel to PLC Row, Column, Data, Handsake. and send 1 tag back handshake. YOu'll need to indirect address the data into the atg on both ends but it can be done. Keep looking and good luck. Share this post Link to post Share on other sites