dcooper33
Lifetime Supporting Member + Moderator
Hi all,
Trying to find an answer to what I can't believe hasn't already been asked and answered on this site or elsewhere on the interwebz. But if it has, I surely can't find it.
I've done a fair amount of VBA work vis-à-vis Excel and controllogix processors, but I've only ever worked with controller-scoped tags, until now. I've got to populate a string and real member of a UDT, within an array, within program-scoped tags.
Can anyone shed some light on the proper syntax for DDEPoke tag name strings when pointed to a program tag?
Normally, I would do something like:
So if "My_UDT_Array" is program-scoped, would I do something like the FTView way of looking at it, i.e. "Program:My_Program.My_UDT_Array[" & i & "].My_String"?
Thanks,
Dustin
Trying to find an answer to what I can't believe hasn't already been asked and answered on this site or elsewhere on the interwebz. But if it has, I surely can't find it.
I've done a fair amount of VBA work vis-à-vis Excel and controllogix processors, but I've only ever worked with controller-scoped tags, until now. I've got to populate a string and real member of a UDT, within an array, within program-scoped tags.
Can anyone shed some light on the proper syntax for DDEPoke tag name strings when pointed to a program tag?
Normally, I would do something like:
Code:
Channel = DDEInitiate("RSLinx", My_Topic)
For i = 0 to My_Array_Size
Row = i + 2 '(or whatever row the data starts on)
Column = 1 '(or wherever)
Dest = "My_UDT_Array[" & i & "].My_String"
DDEPoke Channel, Dest, Cells(Row, Column)
Next i
So if "My_UDT_Array" is program-scoped, would I do something like the FTView way of looking at it, i.e. "Program:My_Program.My_UDT_Array[" & i & "].My_String"?
Thanks,
Dustin