Visual Basic (VBA) for TestPartner

Prerequisites: Students should have a basic knowledge of any programming or scripting language and be comfortable with the topics covered in RTTS' training course entitled Introduction to Compuware TestPartner.

Objectives: Upon completion of this course, participants should be able to:
Use decision constructs and loops
Parse strings using VBA string-parsing functions
Create and use arrays
Read and write to plain text files
Understand the fundamentals of COM
Access the services of Excel through its COM interface


Topics:
Variables: declarations, data types and scope
Control flow structures: if...else...end if; for loops, for each loops, do loops, select case
User-defined functions
Debugging scripts using the VBA debugger
String functions
Plain text file I/O
Arrays: single and multidimensional; static and dynamic
COM Automation