Posts by Kalyan035

    Re: Copy data from a cell that reads live values from PLC via DDE connection.

    HI ,
    I have tried this method , but for some reason it gives me error , can some one help me .
    I have DDE link on cell "B3" and it gets updated on Cell "D2" via this method once, but, Next time the same row gets updated deleting the previous value.

    Can some one explain me what is actually meant by this
    ThisWorkbook.Names("Output2").RefersTo = Worksheets("Sheet1").Range("Output2").Offset(1, 0)

    Also how should
    DDE link look like , i have this "RSLINX|ex1!'Input,L1,C1"

    help me understand it