User`s guide

3
Programming with Excel
Builder Components
Overview . . . . . . . . . . . . . . . . . . . . . 3-2
When to Use a Formula Function or a Subroutine . . . 3-3
Initializing Excel Builder Libraries with Excel . . . . 3-4
Creating an Instance of a Class . . . . . . . . . . . 3-6
CreateObject Function . . . . . . . . . . . . . . . . 3-6
Visual Basic New Operator . . . . . . . . . . . . . . 3-6
Calling the Methods of a Class Instance . . . . . . . 3-9
Processing varargin and varargout Arguments . . . . 3-11
Handling Errors During a Method Call . . . . . . . . 3-13
Modifying Flags . . . . . . . . . . . . . . . . . . 3-14
Array Formatting Flags . . . . . . . . . . . . . . . . 3-14
Data Conversion Flags . . . . . . . . . . . . . . . . 3-16