I need your help, how to use matrix in vba for PI archive input.
I looked at your macros and you have the Datalink PIPutVal code, so I assume your problems are just with iterating through the values.
If you are using your macro RunCode2 I noticed:
you do not have the Set command when assigning the ranges such as:
xValorTag = Cells(3, Col)should be
Set xValorTag = Cells(3, Col)
Also you later set the value for ResultCell such as
resultCell = "OK"
but you have not yet assigned the range for ResultCell in a previous line.
Retrieving data ...