Excel Bill of Materials

Out of category
1

Hello

I would like to create a nomenclare from solidworks, to VBA. For this fact, I have an excel file and I would like it to write dadant starting at box A5. Then he puts away all the pieces thanks to their reference number (written in the room property). The best would be a manager that would allow him to manage the fishing number on all the components (Even screws with several configurations)

Example attached

Is it possible? 

Thanks in advance


capture.png
2

Hello 

See this link among others

https://www.lynkoa.com/sites/default/files/questions/answer/18/06/2013/sans_titre.png

@+

3

In VBA it must be feasible.

Here is an example to export a nomenclature, you find a multitude of them with a little research, see if you find something that corresponds to your request and if not, start adapting it and come back here.

For research a few things like API solidworks export bom should have good results.

:https://www.lynkoa.com/forum/solidworks/enregistrer-bom-assemblage-en-format-excel-avec-une-macro

4

Thank you for your answers, but I already know how to export a nomenclature to ecxel in vba, but not with the required constraints

Thank you

5

Hello

Here is a macro to extract sorting and save an xls file from the BOM

For it to work properly, no empty line between  box  A5 and last box column A

 

CDLT


generation_table_nomenclature.swp
2 Likes
6

Thank you very much Yannick,

The macro you sent me doesn't work, in attachment what it displays.

However the difficulty of my problem is that it skips lines when there is no piece at the marker (example: no marker piece 1, marker room 2 will be displayed on line 6.

Thank you


capture.png