You are not registered yet. Please click here to register!


 
 
plc storereviewsdownloads
This board is for PLC Related Q&A ONLY. Please DON'T use it for advertising, etc.
 
Try our online PLC Simulator- FREE.  Click here now to try it.

---------->>>>>Get FREE PLC Programming Tips

New Here? Please read this important info!!!


Go Back   PLCS.net - Interactive Q & A > PLCS.net - Interactive Q & A > LIVE PLC Questions And Answers

PLC training tools sale

Reply
 
Thread Tools Display Modes
Old June 7th, 2019, 10:51 AM   #1
Richard_123
Member
United Kingdom

Richard_123 is offline
 
Join Date: Mar 2010
Location: Bristol
Posts: 5
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??
  Reply With Quote
Old June 12th, 2019, 09:42 AM   #2
KuulKuum
Member
United States

KuulKuum is offline
 
Join Date: Jun 2006
Location: Texas
Posts: 208
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
  Reply With Quote
Reply
Jump to Live PLC Question and Answer Forum

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Topics
Thread Thread Starter Forum Replies Last Post
FactoryTalk SE - Execute VBA code when interval elapsed rasen LIVE PLC Questions And Answers 2 June 10th, 2019 07:55 AM
FactoryTalk View SE VBA Tags to Excel kota_rt LIVE PLC Questions And Answers 25 June 3rd, 2019 05:33 AM
FactoryTalk View SE Macro call from VBA mushburger LIVE PLC Questions And Answers 0 February 25th, 2015 10:57 AM
VBA Control FactoryTalk SE jparker83 LIVE PLC Questions And Answers 0 June 27th, 2013 11:10 AM
Running FactoryTalk View SE V5.0 to work with FactoryTalk Service Platform 2.40 ? alpine LIVE PLC Questions And Answers 15 December 15th, 2011 06:49 PM


All times are GMT -5. The time now is 10:24 PM.


.