MATLAB Excel Builder

Application Deployment

Now create an Excel add-in (.xla) from your VBA code. Return to the Excel worksheet window and save the file as an .xla file to the <project_dir>\distrib directory.

Here are the steps necessary to create an Excel add-in from the generated VBA code. If these steps do not work, refer to your Excel documentation on creating a .xla file:

1. Start Excel.
2. Choose Tools -> Macros -> Visual Basic Editor.
3. In the Microsoft Visual Basic window, choose File -> Import.
4. Select VBA file (.bas) from the <projectdir>distrib directory.
5. Close the Visual Basic Editor.
6. In the Excel worksheet window, choose File -> Save As... .
7. .Set the Save as type to Microsoft Excel add-in (*.xla).
8. Save the .xla file to <projectdir>\distrib.

You can also deploy files in *.xls and *.bas formats. To deploy in *.xls format, follow the steps above but change the Save as type in Step 7 to *.xls. To deploy as VBA code, follow Steps 1 - 4 above only.

Testing the Model

Packaging and Distributing the Component