DefelRadar
Member
- Join Date
- Jun 2003
- Posts
- 16
I am reading data from an Omron PLC using CX-Server into an Excel file. The data populates 4 different columns and that data is overwritten everytime the PLC updates. I am trying to figure out a way using Excel, VB and/or any other combo where I can save the values that are in those 4 columns and shift them down a row thereby allowing the new data to come in while saving the old data to populate a database of sorts. My 4 columns look like the following in excel:
=CDMDDE|'C:\Program Files\OMRON\CX-Server\C200HSexcel.cdm'!'\PrintNumber'
=CDMDDE|'C:\Program Files\OMRON\CX-Server\C200HSexcel.cdm'!\DataPoint1
=CDMDDE|'C:\Program Files\OMRON\CX-Server\C200HSexcel.cdm'!\DataPoint2
=NOW()
As it can be seen all of those columns change the second that values in their respective locations change. So I was wondering if anyone knew how to get those values and save or freeze them so they can be inserted below the new/updated values before they are overwritten.
Thanks again!!
=CDMDDE|'C:\Program Files\OMRON\CX-Server\C200HSexcel.cdm'!'\PrintNumber'
=CDMDDE|'C:\Program Files\OMRON\CX-Server\C200HSexcel.cdm'!\DataPoint1
=CDMDDE|'C:\Program Files\OMRON\CX-Server\C200HSexcel.cdm'!\DataPoint2
=NOW()
As it can be seen all of those columns change the second that values in their respective locations change. So I was wondering if anyone knew how to get those values and save or freeze them so they can be inserted below the new/updated values before they are overwritten.
Thanks again!!