A
Does anyone know how make a dynamic remote reference in Excel without having to do a macro?
For example, I have the fixed remote reference "=RSLINX|TOPICNAME!'N7:0'" in a cell. To see a different register I have to edit the reference.
What I would like to do is build an excel formula where the 'N7:0' part is the contents of a cell, and I can simply copy and paste the function down a whole column of register references. This way I won't need to bother with messy excel macros. I have tried and the normal excel cell referencing rules don't seem to apply to DDE items.
The other thing is how to poke values from excel to rslinx without macros. I have looked at the examples in the RSLinx help and only want to consider macros as a last resort.
Anthony Kerstens P.Eng.
For example, I have the fixed remote reference "=RSLINX|TOPICNAME!'N7:0'" in a cell. To see a different register I have to edit the reference.
What I would like to do is build an excel formula where the 'N7:0' part is the contents of a cell, and I can simply copy and paste the function down a whole column of register references. This way I won't need to bother with messy excel macros. I have tried and the normal excel cell referencing rules don't seem to apply to DDE items.
The other thing is how to poke values from excel to rslinx without macros. I have looked at the examples in the RSLinx help and only want to consider macros as a last resort.
Anthony Kerstens P.Eng.