Hello,
New to the forum. I run a monthly inventory in excel for tank farm levels of 13 tanks. Previously, I had to go into RSLogix and search for each tag that corresponds to the tanks temperature transmitter and level transmitter and manually enter those values into an excel workbook in different cells and on different sheets.
I just found a way to link each cell to its corresponding tag through a DDE connection using RSlinx. The first problem is the RSlinx application has to be manually opened first before I open the spreadsheet in order for the cell values to populate. The second problem is all of the values are live...I need a snapshot of all these tag values for one instance at the end of the month. I can't have them continuously updating. I've seen vb code where a button click action will open RSlinx, read an array of tag values and write those tag values into a consecutive range of cells in Excel and then close the RSLinx application. This would ALMOST work for me...instead, I need a button that opens the RSLinx application, pulls the tag values from different tags I designate, and then write that data to the correct cells in different sheets in the same workbook, then close the RSLinx application. I've searched everywhere and haven't found anything that matches exactly what I need but I'm right on the cusp!!! Can someone point me in the right direction?
Thanks in advance!!
Vito
New to the forum. I run a monthly inventory in excel for tank farm levels of 13 tanks. Previously, I had to go into RSLogix and search for each tag that corresponds to the tanks temperature transmitter and level transmitter and manually enter those values into an excel workbook in different cells and on different sheets.
I just found a way to link each cell to its corresponding tag through a DDE connection using RSlinx. The first problem is the RSlinx application has to be manually opened first before I open the spreadsheet in order for the cell values to populate. The second problem is all of the values are live...I need a snapshot of all these tag values for one instance at the end of the month. I can't have them continuously updating. I've seen vb code where a button click action will open RSlinx, read an array of tag values and write those tag values into a consecutive range of cells in Excel and then close the RSLinx application. This would ALMOST work for me...instead, I need a button that opens the RSLinx application, pulls the tag values from different tags I designate, and then write that data to the correct cells in different sheets in the same workbook, then close the RSLinx application. I've searched everywhere and haven't found anything that matches exactly what I need but I'm right on the cusp!!! Can someone point me in the right direction?
Thanks in advance!!
Vito
