Solutions for efficient product design

Direct interface to export BOM to Excel

5. April 2019 | Tips & Tricks

Target group:

All users who process BOM data in Microsoft Excel.


  • Flexible export from Creo Parametric to Microsoft Excel
  • Visual Basic macros in Excel are not required anymore


EMX BOM dialog with export options

Following options are available:
(1) export with usage of VBA macros
(2) usage of direct interface

Definition of Excel export in EMX optionsSettings can be adjusted in EMX Options dialog:
– Row number to start with
– Page break at row number
– Name of sheet
– Assignment of EMX parameter to Excel column
– Assignment of EMX project parameter to Excel table cell

Result in ExcelResult in Excel with usage of direct interface in EMX






Mit dem Laden des Videos akzeptieren Sie die Datenschutzerklärung von YouTube.
Mehr erfahren

Video laden


Since Expert Moldbase Extension,, 10.0 M031.