Bi-directional Integration


SolidWorks Product Configurator is a powerful and lightweight solution for the automatic

  • Creation of products and their variants in CAD
  • Creation of 3D models and drawings
  • Creation of neutral formats in 3D/2D
  • Creation and management of BOMs
  • Management of configured products

The configurator was designed in such a way that the entire logic for creating the models and drawings can be implemented in Excel. The configuration in SolidWorks is done only via VBA macro, which allows access to all functions of the SolidWorks API.

  • Easy customisation to company-specific specifications and workflows through VBA macros
  • Error reduction by splitting the VBA macros into small, functional blocks
  • Creation of models and drawings from scratch without a template possible
  • Use of all file formats supported by SolidWorks possible

By using VBADC it is possible to reference any DLL in the SolidWorks macro, which can be accessed later by the dynamically loaded modules.

Despite the VBA limitation, approximately 90000 steps can be guaranteed in Excel in the current configurator.


When creating the configurators, the macros are compiled in Excel from an SQL database. This guarantees that all configurators always work with the latest macros.


There are no limits to the use of the configurator. Any number of SolidWorks CAD instances are possible in the network or on one computer. The only limitation is the hardware or the quantity of software licences.


A web interface is available for remote control of the configurators. The complete logic is already integrated in the server, so that simple modifications are possible. The server is programmed in Blazor.


The configurator can be integrated into BiI ERP-PDM to transfer configured models automatically into the PDM and synchronise data with the ERP system.