opc

Hey guys new to this but I'm trying. So im using excel as an OPC client through RSLinks paste special. I am copying data from the plc and moving it down when the PLC tells excel to (ie when a value goes high copy and paste values down a few lines). So i have a macro to copy and move data down...

Hey Everyone! I'm stumped on the last step of a VBA challenge. I'd really appreciate any advice or suggestions. I feel like I'm doing something obviously wrong. Summary of my problem: (Scroll to the bottom to go directly to the code and screenshots) I'm using an OPC connection to send data...

Hi, I have the following code, but I keep getting 'error 91: Object variable or With block variable not set'. Does somebody have a solution to this? Thank you very much! The code is moving the value of A1 and B1 to A2 and B2, the value of A2 and B2 to A3 and B3, ... every time A1 changes...

Hello, I am trying to log data which is suplied by an OPC client (S7 - 200 PC Access). I managed to show the data in a cell, i.e. A1. Every time the data is changed, i want to write the data to the cell below the last one (A2 then A3 then A4 ....). But it's really important that the logging...