AddIn

AddIn object stores The C function name (Procedure), the C signature (TypeText - a character string specifying the return type and C function argument types), the name Excel uses for your function (FunctionText), and the argument prompt (ArgumentText) that shows up after you type the function name and type Ctrl-Shift-A. You can also specify the category (Category) and help text (FunctionHelp) used in the Function Wizard. This information is supplied to xlfRegister when xlAutoOpen is called by Excel.

There is more than one way to create AddIn objects. The simplest way is to specify the information Excel needs directly: