User`s guide

Usage Examples

Magic Square Examples . . . . . . . . . . . . . . . 4-2

Creating the Project . . . . . . . . . . . . . . . . . 4-3

Building the Project . . . . . . . . . . . . . . . . . 4-5

Adding the Excel Builder COM Function to Excel . . . . . 4-5

Illustration 1. Output Magic Square Results to Excel . . . . 4-5

Illustration 2. Transpose the Output . . . . . . . . . . . 4-6

Illustration 3. Resize the Output . . . . . . . . . . . . 4-6

Inspecting the Visual Basic Code . . . . . . . . . . . . 4-7

Using Multiple Files and Variable Arguments . . . . . 4-8

Creating the Project . . . . . . . . . . . . . . . . . 4-8

Building the Project . . . . . . . . . . . . . . . . . 4-11

Adding the Excel Builder COM Functions to Excel . . . . . 4-11

Illustration 4: Calling myplot . . . . . . . . . . . . . . 4-13

Illustration 5: Calling mysum Four Different Ways . . . . . 4-14

Illustration 6: myprimes Macro . . . . . . . . . . . . . 4-15

Inspecting the Visual Basic Code . . . . . . . . . . . . 4-16

Spectral Analysis Example . . . . . . . . . . . . . 4-18

Building the Component . . . . . . . . . . . . . . . . 4-18

Integrating the Component with Visual Basic for Applications 4-20

Creating The Visual Basic Form . . . . . . . . . . . . 4-22

Adding The Spectral Analysis Menu Item to Excel . . . . . 4-29

Saving the Add-in . . . . . . . . . . . . . . . . . . 4-30

Testing The Add-in . . . . . . . . . . . . . . . . . . 4-31

Package the Add-in . . . . . . . . . . . . . . . . . . 4-34