VBA with Proficy HMI/SCADA iFIX

 

GE Intelligent Platforms Training
Using VBA with Proficy HMI/SCADA iFIX
Date 8 October 2019 – 11 October 2019
Time 8:00 AM TO 5:00 PM
Location Advantage/Atlanta
Registration Register Today

Using VBA with Proficy HMI/SCADA – iFIX 
8:00 AM to 5:00 PM (4 days)
Price: $2,495 per seat

 Course Description

Using VBA with Proficy HMI/SCADA – iFIX is designed for those who wish to acquire a basic knowledge of Visual Basic for Applications (VBA) within iFIX. This knowledge will assist the student in the implementation of highly customized iFIX HMI/SCADA systems. The course begins with an introduction to VBA and the ways it’s incorporated into an iFIX system. Lectures, coding examples, and labs enable the student to become familiar with the tools provided in iFIX for the creation of, testing, and trouble-shooting of advanced features created with VBA

Who Should Attend? This course is principally designed for process, automation, or instrumentation engineers and system integrators who will be developing, configuring, and maintaining advanced iFIX systems.

Are There Any Prerequisites? A working knowledge of iFIX is required. Completion of Proficy HMI/SCADA – iFIX Fundamentals course (154) is recommended. Familiarity with some programming language would be helpful, but not required.

What Tasks Will Be Taught in This Class? Upon completion of this Course, the student will be able to:

  • Create VBA procedures (functions and sub-procedures)
  • Create (declare) variables of various data types and use them in a procedure
  • Use code structures including decisions (i.e. If Then Else) and loops (i.e. For Next)
  • Use the VBA MessageBox and InputBox functions
  • Use and create VBA forms
  • Read and Write iFIX tag data using VBA
  • Detect and handle errors inside custom procedures
  • Use VBA testing and debugging tools
  • Use iFIX Subroutines and Methods
  • Use VBA Automation to manipulate other applications (i.e. Excel)

Using VBA with Proficy HMI/SCADA – iFIX Course Agenda (Schedule and content may vary.)

Day 1
Morning: VBA Overview VBA terminology and an introduction to the VBE (Visual Basic Editor). VBA and iFIX Details on how VBA functions within iFIX and how to use VBA Help.
Afternoon: Procedures and Code Locations  Create procedures and use procedure arguments. iFIX subroutines and methods  Using iFIX subroutines and methods and invoking code in iFIX applications.

 

Day 2
Morning: Variables  Understand and create (declare) variables of various data types. VBA Debugging Tools  Using VBA tools, like Watch Window and Locals Window, to debug code. Decision Code  If Then Else and other decision code.
Afternoon: Expression Use functions and variables to make complex expressions. Functions Use pre-built functions (Message Box and Input Box) and create new functions.

 

Day 3
Morning: Forms Create and use Forms, including unloading and hiding Forms. VBA and iFIX Accessing the iFIX Process Database
Afternoon: Looping Code and Arrays  Use For loops and Do loops. Create and populate array variables. Error Handlers Use error handlers to create better code.

 

Day 4
Morning: Accessing Relational Databases Access Relational Databases using ADO (ActiveX Data Object). Collection Object Create and use collections to enhance an application. ActiveX Using ActiveX with iFIX.
Afternoon: VBA Automation Use VBA Automation to make References to other applications Win32 API  Using the Windows Applications Programming Interface from iFIX VBA