User`s guide

ManualsBrandsMATLAB ManualsOtherBUILDER EX 1

Handling Errors During a Method Call .............. 2-13

Modifying Flags

................................... 2-14

Array Formatting Flags

............................ 2-14

Data Conversion Flags

............................. 2-16

Usage Examples

Magic Square Examples ............................ 3-2

Creating the Project

............................... 3-2

Adding the Excel Builder COM Function to Excel

....... 3-3

Illustration 1. Output Magic Square Results to Excel

.... 3-3

Illustration 2. Tran sp ose the Output

.................. 3-4

Illustration 3. Resize the O utput

..................... 3-4

Inspecting the Visual Basic Code

..................... 3-5

Multiple Files and Variable Arguments Example

..... 3-6

Creating the Project

............................... 3-6

Adding the Excel Builder COM Function to Excel

....... 3-7

Illustration 4: Calling myplot

........................ 3-8

Illustration 5: Calling mysum Four Different Ways

...... 3-9

Illustration 6: myprimes Macro

...................... 3-10

Inspecting the Visual Basic Code

..................... 3-12

Spectral An alysis E xample

......................... 3-13

Building the Componen t

............................ 3-13

Integrating the Component Using VBA

................ 3-15

Testing the Add-In

................................ 3-27

Packaging and Distributing the Add-In

................ 3-29

Function Wizard

Overview of the Function Wizard ................... 4-2

vi Contents