SOLIDWORKS Macro: BOM Checker for Missing Properties

What this macro does

Scans BOM rows for missing part number, description, material and revision values, then writes a CSV report.

Best for

• Release readiness checks
• BOM quality control
• Property cleanup before export

Inputs

• Open drawing or assembly with BOM table

Outputs

CSV report

Filename rules

{document}_bom_property_check.csv.

How to use

1. Test on copied SOLIDWORKS files first.
2. Download and import BomPropertyChecker.bas into a SOLIDWORKS VBA macro project.
3. Open the required document type: Drawing, Assembly.
4. Run main from the macro editor or assign it to a toolbar button.
5. Review all generated files before using them for production release.

Limitations

• Checks visible BOM table text.
• For workspace-wide BOM visibility and where-used search, use Solidise.