Skip to main content

RUN Excel Macro after Creo BOM Export

Overview​

This video demonstrates how to automatically trigger an Excel VBA macro after Nitro-BOM completes a BOM export from Creo. This powerful automation feature lets you chain post-processing steps onto the export — formatting the report, calculating costs, generating charts, sending email notifications, or transforming the data for import into another system. Instead of manually running a macro every time you export, Nitro-BOM can call a specified macro immediately after the Excel file is generated. The video covers how to configure the macro name in Nitro-BOM's settings, how to structure your Excel macro to work with the exported data, and how to handle common scenarios like formatting columns, adding summary rows, or copying data to other sheets. This feature turns a simple BOM export into a fully automated reporting pipeline — from Creo assembly to finished, formatted report in one click.

Key Steps​

  1. Create an Excel VBA macro that performs your desired post-processing
  2. Save the macro in the Excel template or workbook used for BOM exports
  3. In Nitro-BOM settings, specify the macro name to run after export
  4. Execute a BOM export — Nitro-BOM will automatically run the macro when the export completes
  5. Review the final Excel file to confirm the macro processed the data correctly

Tips​

  • Test your macro independently before connecting it to Nitro-BOM's auto-run feature
  • Use macros for formatting, cost calculations, data validation, or report distribution
  • Store macros in a shared template so all team members get the same post-processing