Home      Training    Products     Services    DS Info    Clients 

Visual Basic

   Visual Basic for Applications

          This course teaches developers how to automate their applications using Visual Basic for Applications.  We will discuss how to get the most out of event driven programming.  The course code and examples can be applied to any Microsoft Office application, or Visual Basic 6 programs.  This is an introductory level course in VBA.  Students should have previous experience developing in an environment using then VBA coding language. (3 days with hands on)

Topics:

v      Into to Visual Basic for Applications.

v      What are procedures and how do we create them?

v      Where does code belong.

v      Variables, constants, and enumerations.

v      Logic and looping structures

v      Executing code from an event

v      Working with strings, dates, and numbers.

v      Creating and using objects.

v      An introduction to ADO.

v      Techniques for debugging

v      Error handling methodology

v      Examples, examples, examples