Back to all work

One-click release package

A SOLIDWORKS VBA macro that walks an assembly, checks every file's custom properties, and exports PDFs, DXFs, STEP files and a BOM in Excel, named and foldered the way the shop expects.

Type
Portfolio project
Service
SOLIDWORKS automation
Time saved
[X] min per release
Delivered
Macro, notes, video

The problem

Releasing a drawing package by hand means opening every drawing, exporting each format, renaming files and catching the missing material or revision. On a 60-part assembly that's an afternoon, and errors still slip through.

How I approached it

  • Traverse the top-level assembly and collect each unique part, subassembly and drawing.
  • Check required custom properties first, and stop with a clear list if anything is missing.
  • Export each file type by rule: PDF for every drawing, DXF for sheet metal flat patterns, STEP for purchased-part vendors.
  • Write the BOM to an Excel template and save everything to a dated release folder.

Results

A release that took [X] minutes by hand now takes [Y] minutes, with no missed exports. [Record the demo video on the weld fixture assembly.]

What was delivered

  • Macro source, commented
  • Setup notes for property names and folder rules
  • A short walkthrough video
What the macro does
What the macro does
Placeholder for screen recording still: the property check report
Screen recording still: the property check report
Placeholder for the release folder it produces
The release folder it produces
RevDescriptionDate
AFirst release of this site[Launch date]