Macro Export Bill of Materials to Excel

Hi all

I'm a beginner in macro, we use Solidworks at the BE and I want to automate some tasks. Currently, I export the bills of materials to Excel since the drawing and I integrate them into our ERP. I'd like a macro to export the nomenclature with the same name as the drawing and in the same folder.

I tried via Chatgpt impossible.

I've done some research but I can't find what I'm looking for, does anyone have a macro similar to my request in their toolbox?

Check out this topic:
https://forum.mycad.visiativ.com/t/export-nomenclature-vers-excel-avec-une-macro-vba/104588
Or:
https://forum.mycad.visiativ.com/t/export-nomenclature-vers-excel-avec-une-macro-vba/106042
And to finish this one:
https://forum.mycad.visiativ.com/t/exportation-vba-nomenclature-solidworks-vers-excel/106397
Edit: with the search of the forum the topics are also findable and without the need for a chat! :wink:

3 Likes

Thank you for your quick answer, I had seen these topics but the first topic it integrates a nomenclature, exports it and deletes it. I would like the macro to select the nomenclature that is in the drawing and export it to xlsx.