Export to Excel Macro

When you export models to Excel Macro, a VBA script (*.bas) is generated for each output. For more information, see Model Export to Excel Macro.

Export a model to Excel Macro

  1. File > Export Model > Excel Macro

    ClosedExport to Excel Macro window

  2. Set the Base Name (defines the file names <base name>_<output>) and the Target Folder.

  3. Select the Type of data you want to export.

    4. Select the Inputs and Outputs to export in the table. The order in which the inputs are passed to the exported model can be changed using the and buttons.

      You can use the standard Ctrl/Shift selection functions in the table, or click and hold Lmb and drag the cursor over the cells/rows you want to select. The position of the inputs in the exported model is shown in the # column.

      To export only used inputs, select Used Inputs Only.

  5. Click Export.

  6. The export starts and the files are saved to the specified path. A link to the export folder is displayed in the log window.