Macro

To export a SolidWorks BOM to Excel, you have three paths — and choosing the wrong one is how you end up maintaining a 200-line macro for two months before admitting it doesn’t quite work. A post on r/SolidWorks showed exactly that: a macro that exported an assembly BOM to Excel with description, material, length, thickness, quantity, and supplier data. It mostly worked. Six comments later, nobody had a better answer than “looks fine to me.” The approach was fine — the architecture was wrong. ...

The request surfaces a few times a month on r/SolidWorks and in engineering Slack channels. Someone has two hundred parts. They need a drawing for each one. Same template, same three views, title block linked to the same properties. They want to leave it running overnight. The top replies say “use Task Scheduler” or “ask ChatGPT to write a macro” and the original poster comes back in a week saying neither worked. ...