Macros

Free SolidWorks and Excel Macros for Everyday Automation

Repetitive CAD and spreadsheet tasks are the perfect candidate for automation. This library collects ready-to-run macros for SolidWorks and Excel, covering everyday engineering jobs like batch dimensioning, drawing cleanup, part property updates, and spreadsheet data processing that would otherwise eat hours of manual work.

Instead of searching scattered forum threads and adapting code snippets, you can browse a single, organized collection. Sort the table by any column — macro name, tags, license, or details — or use your browser's search (Ctrl+F) to jump straight to a specific keyword. Each row links directly to the source so you can review and copy the code, then run it in your own installation.

What You'll Find

• SolidWorks automation — macros for part and assembly operations, drawing sheets, notes, and properties.
• Excel / VBA utilities — spreadsheet macros for engineering data, calculations, and report formatting.
• Tags and licenses — each macro records its tag, license, and a short description so you can judge fit before downloading.

How to Run a Macro

Open the linked source for the macro you need and copy the code. In SolidWorks, go to Tools > Macro > New, paste the code, and run it. In Excel, press Alt+F11 to open the VBA editor, insert a module, paste the code, and press F5. Before running any downloaded code in your environment, review it and test it on a copy of your data.