Can anyone point me to a Solidworks macro to extract a bill of materials to an excel file?
I don’t have a macro that does what you want, but I can tell you what we do. I have a macro that places an indented BOM with the correct formatting into our assembly. The user then checks that the BOM has what they want to export and that things that should be excluded from the BOM are excluded. Then we select the BOM and save it as text. We then have a custom python script that takes that text file and adjusts things and puts it into an excel template. Saving the BOM as text and then setting which columns come into excel as text rather than general keeps leading and trailing 0 in part numbers and index numbers from disappearing.
Yep, we do stuff like that too, but I’m trying to get to a one-click solution similar to what we do to export neutral formats. Click, done.
1 Like
That last one not only does what I want, it also adds thumbnails, which is very handy. Many thanks for the help.
1 Like
You know you can export the BOM to excel with out a macro, right click on the bom and select export to xls format the is also a tick box for thumbnails.
2 Likes
Yes, just trying to streamline the process.
Be careful
with complex Assemblies that I usally deal with.
Users might have to edit the bom to hide stuff that won’t be made or purchased.
I have seen many users forget to turn exclude from bom for bought out assemblies….
Also knocking out the sheet cut list row or row that is part of the weldment reside in.
Also typos.
Yes, Q.C. is important.
1 Like