Learn more about MATLAB Builder EX

Overview of the Integration Process

Each MATLAB Builder EX component is built as a COM object that you can access from Microsoft Excel through Microsoft Visual Basic for Applications (VBA). This topic provides general information on how to integrate the MATLAB Builder EX components into Excel using the VBA programming environment. It assumes that you have a working knowledge of VBA and is not intended to discuss how to program in Visual Basic. Refer to the VBA documentation provided with Excel for general programming information.

You can integrate the MATLAB Builder EX components into a VBA project by creating a simple code module with functions and/or subroutines that load the necessary components, call methods as needed, and process any errors. In general, you need to address the following items in any code written to use the MATLAB Builder EX components:

• When to Use a Formula Function or a Subroutine

• Initializing MATLAB Builder EX Libraries with Microsoft Excel

• Creating an Instance of a Class

• Calling the Methods of a Class Instance

• Processing varargin and varargout Arguments

• Handling Errors During a Method Call

• Modifying Flags

  Note   All code samples in these topics are for illustration purposes and reference a hypothetical class named myclass contained in a component named mycomponent with a version number of 1.0.

Programming with MATLAB Builder EX

When to Use a Formula Function or a Subroutine

© 1984-2009- The MathWorks, Inc.    -   Site Help   -   Patents   -   Trademarks   -   Privacy Policy   -   Preventing Piracy   -   RSS