wilkerson29847
Member
Good morning.
I originally posted about this topic on April 4th and ran into an issue with the IT department and their rules but have since found a resolution.
I acquired another laptop from IT and an OEM version of RS Linx for the Excel to PLC interface. I can get the data to read from the PLC using the Copy DDE/OPC link in RS Linx and pasting into Excel. Here is my question:
We are using an MES system and I want to be able to update the Part numbers in the PLCs from this master Excel File and all of these Part numbers are string values. All of the examples I have seen show updating multiple tags with one command button in excel but they are all in sequence, e.g. Tag[0], Tag[1], Tag[2], etc.
I think the example I saw was from someone or somewhere on this forum.
In my situation the tags are part of a UDT like the following:
Tool[1].SAP_Number_1
Tool[1].SAP_Number_2
Tool[2].SAP_Number_1
Tool[2].SAP_Number_2
Tool[3].SAP_Number_1
Tool[3].SAP_Number_2............and so on.
Also, there are between 40 and 50 PLCs that will have to be updated depending on what part numbers change with revision changes. Am I wasting my time or is there a fairly easy way to do this? Do I have to have a separate Command Button in Excel for SAP_Number_1 and SAP_Number_2? I currently have a worksheet made for each machine, so would I need 2 Command Buttons per sheet for a Read operation and 2 per sheet for a Write Operation?. Can someone give me some direction? I have never tried to send and receive data from Excel to/from a PLC so I am pretty clueless on the VBA side of Excel.
Thank you to everyone helping those of us with less experience and knowledge!!
Report Post
I originally posted about this topic on April 4th and ran into an issue with the IT department and their rules but have since found a resolution.
I acquired another laptop from IT and an OEM version of RS Linx for the Excel to PLC interface. I can get the data to read from the PLC using the Copy DDE/OPC link in RS Linx and pasting into Excel. Here is my question:
We are using an MES system and I want to be able to update the Part numbers in the PLCs from this master Excel File and all of these Part numbers are string values. All of the examples I have seen show updating multiple tags with one command button in excel but they are all in sequence, e.g. Tag[0], Tag[1], Tag[2], etc.
I think the example I saw was from someone or somewhere on this forum.
In my situation the tags are part of a UDT like the following:
Tool[1].SAP_Number_1
Tool[1].SAP_Number_2
Tool[2].SAP_Number_1
Tool[2].SAP_Number_2
Tool[3].SAP_Number_1
Tool[3].SAP_Number_2............and so on.
Also, there are between 40 and 50 PLCs that will have to be updated depending on what part numbers change with revision changes. Am I wasting my time or is there a fairly easy way to do this? Do I have to have a separate Command Button in Excel for SAP_Number_1 and SAP_Number_2? I currently have a worksheet made for each machine, so would I need 2 Command Buttons per sheet for a Read operation and 2 per sheet for a Write Operation?. Can someone give me some direction? I have never tried to send and receive data from Excel to/from a PLC so I am pretty clueless on the VBA side of Excel.
Thank you to everyone helping those of us with less experience and knowledge!!
Report Post