Running Excel Macros

You can run macros that were saved with the Microsoft Excel® spreadsheet and configure the order in which macros are run and cells are mapped to Optimization Process Composer parameters. For example, you can map a parameter to a cell in a worksheet, run a macro that calculates a new value for the cell, and map the calculated value back to a new parameter.


Before you begin: To run an Excel macro on a 3DOrchestrate Station, you must select the Developer tab in Excel and do the following:
  1. Select Macro Security.
  2. From the Macro Settings, select Enable all macros (not recommended; potentially dangerous code can run).
  3. Select Trust access to VBA project object Model.
  4. Click OK to save your settings.

Note: You must store your Excel macros within your workbook and not in the Excel Personal Macro Workbook. For details, see the Excel documentation.

See Also
About the Excel Adapter
Mapping Between Parameters and Cells
Using Advanced Options
Setting Execution Permissions
  1. From the Applications section of the action bar, click Excel and drop it on the process diagram.
  2. Double-click Excel .
    The Excel Editor appears.
  3. From the Excel Editor, click the Macros tab.
  4. From the Macros menu, select a macro and click Add macro .
    The macro appears at the end of the Action Order list.
  5. If desired, use the arrows below the Action Order list to modify the order in which cells are mapped to or from parameters relative to the order in which the macros run.
  6. Click Ok to save your changes and to close the Excel Editor.