FactoryTalk SE VBA Reading PLC Arrays

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 you are wanting is possible but "without" the use of FTV SE and using RSLinx (not the "Lite" version)
Setup a DDE/OPC Topic that will allow Excel to communicate with your PLC controller.

This website should help you accomplish what you are wanting.
http://www.plcdev.com/connecting_controllogix_excel

Good luck :site: