Re: Copy data from a cell that reads live values from PLC via DDE connection.
That line must be outside all routines and at the top of the worksheet code module.
Re: Copy data from a cell that reads live values from PLC via DDE connection.
That line must be outside all routines and at the top of the worksheet code module.
Re: Copy data from a cell that reads live values from PLC via DDE connection.
I think the problem is that Dim vOldVal wont fire with Worksheet_Calculate. Seems that it fires with Worksheet_Changeonly. It is outside all Routines. Its at the top. Doesn't do the trick.
I [ATTACH=CONFIG]59317[/ATTACH]added a screenshot.
Re: Copy data from a cell that reads live values from PLC via DDE connection.
vOldVal doesn't fire - it's a variable that stores the last value of A5 so that the code only runs when that changes. If the code isn't running, then that value isn't changing.
Re: Copy data from a cell that reads live values from PLC via DDE connection.
Well i just checked it. All cells are changing. The cell from the DDE is updating to TRUE. Obviously the cell=TRUE is updating and the target cell changes from "150" to "-100". So obviously there is a conflict with oldval. Maybe we have to enable events? What do you think?
Re: Copy data from a cell that reads live values from PLC via DDE connection.
Well it appears as well. Don't understand where the problem is really! Sorry for bothering you.
Re: Copy data from a cell that reads live values from PLC via DDE connection.
I moved the CopyValues macro after the first EndIf (See pic attached). It works like before, it makes several copies. But why CopyValues wont fire in the loop of the second if as you wrote it at first?
Re: Copy data from a cell that reads live values from PLC via DDE connection.
Please clarify exactly which formulas and values are where.
Re: Copy data from a cell that reads live values from PLC via DDE connection.
[ATTACH=CONFIG]59320[/ATTACH]
As you can see A1 reads from DDE and it is named Input. A3 reads TRUE/FALSE from DDE. A5=A3 and A7=if(A5=FALSE,"100","-100")
C is output and D is Time
Re: Copy data from a cell that reads live values from PLC via DDE connection.
You my friend are the BEST! WOW! It is working. I really appreciate your time. Is there any Donate button for the forum or you? I have a couple of things to work out (like auto saving at the end of the date, start new file the next day, graphs, printing etc...) but I think its enough. I cant ask for more. Thanks again.
Re: Copy data from a cell that reads live values from PLC via DDE connection.
If you feel so inclined there is information in my profile, but there is absolutely no obligation!
Re: Copy data from a cell that reads live values from PLC via DDE connection.
It wont be so fast as my answers as I am not good at online money transactions, but I will manage to do it. Thanks again and sorry for my English. I am Greek, so its not easy for me. Have a nice day and we ll be in touch.
Re: Copy data from a cell that reads live values from PLC via DDE connection.
Your English is a lot better than my Greek, believe me!
Re: Copy data from a cell that reads live values from PLC via DDE connection.
I do believe you. Greek people cant talk Greek properly. I can only imagine about other people. Tough language. Its a bless I didn't had to learn it.
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
Don’t have an account yet? Register yourself now and be a part of our community!