Mpoon
Member
Hi, every one,
I Used Rslinx DDE/OPC function copied a data table value (N7: XX) and paste it as a link to a cell of Excel sheet. The pasted value is changing every 30 seconds.
Does any one know how to copy this value to other cell in the same sheet based on the changes of the PLC data value that happen in PLC data table?
What I mean is how to "Stack it up in Excel". So I can use it to build a chart.
I done it with a "COP" instruction stack it up in PLC, then hot link 300 words to Excel for display and chart.
I Used Rslinx DDE/OPC function copied a data table value (N7: XX) and paste it as a link to a cell of Excel sheet. The pasted value is changing every 30 seconds.
Does any one know how to copy this value to other cell in the same sheet based on the changes of the PLC data value that happen in PLC data table?
What I mean is how to "Stack it up in Excel". So I can use it to build a chart.
I done it with a "COP" instruction stack it up in PLC, then hot link 300 words to Excel for display and chart.