Richard_123
Member
I have a FactoryTalk SE project where I would like to read a CompactLogix string array (up to 2000) and then transfer this data to an Excel workbook.
What I an trying to achieve is:
Copy
Data[0] to Data[1999] (where Data is a CLX string array 2000 long)
to
Workbook, sheet 1, A1 to A2000
I can read individual PLC variables and output this to a workbook. I can also read large amounts of data from one workbook and copy to another workbook but I can not work out how to define a PLC tag as an array using VBA and then copy this.
Anybody got any ideas??
What I an trying to achieve is:
Copy
Data[0] to Data[1999] (where Data is a CLX string array 2000 long)
to
Workbook, sheet 1, A1 to A2000
I can read individual PLC variables and output this to a workbook. I can also read large amounts of data from one workbook and copy to another workbook but I can not work out how to define a PLC tag as an array using VBA and then copy this.
Anybody got any ideas??