Welcome to 3DCADForums

Join our CAD community forums where over 25,000 users interact to solve day to day problems and share ideas. We encourage you to visit, invite you to participate and look forward to your input and opinions. Acrobat 3D, AutoCAD, Catia, Inventor, IronCAD, Creo, Pro/ENGINEER, Solid Edge, SolidWorks, and others.

Register Log in

Export SolidWorks BOM to Excel


I have created a macro that will export a SolidWorks type BOM in a drawing as an .xls file. I actually looked all over the internet and forums, but found nothing exactly as I wanted. So I came up with this.

You can either manually select a BOM in the feature tree or hard code the macro to look for a BOM by traversing the feature tree. It will then save it off as a .csv file which will then be saved off as an .xls file into the same folder as the drawing. If you use the .SaveAsText function to save it as an .xls file you will get a message saying that it is a text file when you open it. I wanted to avoid this and make it fully automated.

Hope this helps

Here is the link
Export SolidWorks BOM to Excel