Extract a BOM directly into an active Excel file?

Out of category
1

Hi all 

I'm looking for a way to extract a bill of materials in the solidworks drawing directly into a dedicated excel file. This excel file allows me to estimate the cost of my part. I'd like to automate all of this a bit.

I know that it is possible to save a bill of materials in XLS format but I would like to go even faster and remove this step.

PS: I haven't found the presentation section of the XD forum if anyone has a link I'm interested.

Thank you in advance 

Good night

 

2

Hello

You have to be able to do things with http://help.solidworks.com/2015/English/api/sldworksapi/Insert_BOM_Table_and_Extract_Data_Example_VB.htm and http://www.lynkoa.com/forum/import-de-donn%C3%A9es-num%C3%A9ris%C3%A9es/export-nomenclature-vers-excel.

Kind regards

1 Like
3

In your macro, don't forget to reference the Excel library (Tools / References / Microsoft Excel xx.0 Object Library). For the management of Excel in VBA you will find a lot of information on https://www.excel-pratique.com/fr/vba.php.

Kind regards

4

Or if you have MyCad tools, there is Smartbom which exports the bill of materials directly to an excel template file of your choice.

5

I don't think my cad is accessible to everyone solidworks user. I have the premium version of Sdw.

 

Thank you d.roger, I'll look at all this. I admit that I'm a beginner in macro.