User Tag List

Results 1 to 3 of 3

Thread: Get A-B Programmable Controller data into Microsoft Excel using RSLinx

  1. #1
    Administrator Shawn Tierney's Avatar
    Join Date
    Sep 2016
    Location
    Berkshires, MA
    Posts
    2,203
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks Thanks Given 
    6
    Thanks Thanks Received 
    2
    Thanked in
    2 Posts

    Get A-B Programmable Controller data into Microsoft Excel using RSLinx


    In Today's article I'll walk you through how you can bring Allen-Bradley Programmable Controller Data into Microsoft Excel 2016 using...

    Click here to view the original article on The Automation Blog
    Looking for affordable automation training? If you are, check out my courses at TheAutomationSchool.com!

  2. #2
    Member BB32152's Avatar
    Join Date
    Mar 2019
    Posts
    1
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Thanks Thanks Given 
    0
    Thanks Thanks Received 
    0
    Thanked in
    0 Posts

    Storing data in Excel

    Does this procedure allow you to store data or is it real time only?
    My client wants to perform 5 task, storing 3 data points for each task and the once a week download the spreadsheet.
    Is this possible

  3. #3
    Administrator Shawn Tierney's Avatar
    Join Date
    Sep 2016
    Location
    Berkshires, MA
    Posts
    2,203
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks Thanks Given 
    6
    Thanks Thanks Received 
    2
    Thanked in
    2 Posts
    @BB32152,

    I'll let the article and video speak for themselves :-)

    If you decide you don't want to write Excel VBA code to automate data collection, there are lots of products out there that will do this for you, plus you can also write PLC code to store data in the PLC and then use a button in Excel to read that stored data into Excel.

    Best of luck,

    Shawn Tierney,
    Instructor at The Automation School
    Looking for affordable automation training? If you are, check out my courses at TheAutomationSchool.com!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •