Using VBA with Proficy iFIX

Class Details

The Using VBA with Proficy iFIX course is designed for those who wish to acquire a basic knowledge of Visual Basic for Applications (VBA) within iFIX. This knowledge will allow the student to generate VBA based solutions for their special system requirements. The course begins with an introduction to VBA and why VBA is so important in today’s applications. Lectures, coding examples, and labs are included in this course on the important aspects of VBA, as well as reference to Visual Basic syntax. This course will demonstrate to the student how to enhance runtime operation to solve special problems.

Who Should Attend?

This course is principally designed for process, automation, or instrumentation engineers and system integrators who will be developing, configuring, and using applications created with iFIX.

Are There Any Prerequisites?

Completion of Proficy iFIX Fundamentals course (GFS-154) is a must! Participants should have a working knowledge of Windows operating systems. Familiarity with some programming language would be helpful, but is not required.

What Tasks Will Be Taught in This Class?

Upon completion of this Course, the student will be able to:

  • Understand how VBA functions inside of iFIX.
  • Create VBA procedures (functions and sub-procedures).
  • Understand and create (declare) variables of various data types (including arrays) and use them to make expressions.
  • Use simple VBA code structures including decisions, loops, and collections.
  • Use the VBA MessageBox and InputBox commands and create VBA Forms.
  • Access iFIX data and use iFIX Subroutines and Methods
  • Create and use Error Handlers in VBA and use VBA debugging tools.
  • Access Relational Databases using ADO (ActiveX Data Object).
  • Use VBA Automation to make References to other applications.

Class Info