Sign in to follow this  
Followers 0
rchristi87

Writing 2D array to RS5K tag

2 posts in this topic

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0