solidworks macro Inserts a BOM table into a PART document

solidworks macro  Inserts a BOM table into a PART document

Document Properties - Parts. Document Properties - ... for bills of materials. To open this page, with a drawing or an assembly BOM open, click Options (Standard toolbar), select the Document Properties tab, and then select Tables > Bill of Materials. ... You must select this option prior to inserting a BOM. If you select it after 

While using an Excel based BOM (as opposed to a standard BOM) is not as flexible as a standard Bill of Materials, there are various customisations which can be done. E.g. if you want a complete project costing (taking into account price per meter length of piping or weldments). Note: in recent versions of SolidWorks it is possible to do totals and equations in standard BOMs, however they require some post manual tweaking.

This post shows how a custom Excel based Bill of Materials for a SolidWorks Assembly drawing can be created.

Find out where BOM templates are stored: Open SolidWorks -> Tools -> Options -> File Locations -> BOM Templates
Open bomtemp-all.xls Look at the various Headings in Row 1.
Remove/Add Columns to suit making sure to type in the SolidWorks File Property name into the "Name Property" box (see image below).
Do NOT remove the Item No. Column or Part No. Column (otherwise your Excel BOM will act strange, adding several duplicate rows into the BOM.) (I spent quite a while caught on this.) FYI this fact is noted in the SolidWorks Knowledge Base. Customers on subscription can view the SolidWorks Knowledge Base at

buy cheap solidworks 2013 only $ 85

 It is not a OEM or tryout version.

 We offer worldwide shippment .

 You can pay by paypal.

Full version  solidworks 2013   at   $85