-Macro(VBA) to Export BOM from active drawing to excel with thumbnails.
-Excel file will have same name as solidworks drawing file .
-file will be placed to folder C:\BOM_FILES
This is direct option with SW2019 and above https://blogs.solidworks.com/tech/2019/05/using-excel-filters-on-an-excel-bom-with-thumbnails.html
If you need macro, then check code by Amen Allah Jlili here Export Bill of Materials to Excel with thumbnails - Blue Byte Systems, Inc.
thank you, man .
but I’m looking for macro
1. Macro(VBA) to Export BOM from active drawing to excel with thumbnails.
2. Excel file will have same name as solidworks drawing file .
3. file will be placed to folder C:\BOM_FILES
What have you tried already? What have you found that almost works for you?
We would really appreciate some effort from you as wel.
I have found nice macro that copies bom from active drawing to clipboard .
Copies a table-style BOM to the clipboard, where it can be pasted into applications such as MS Excel
What is missing is “save as excel to specific folder “
The goal is to make it with one click.
Take a look at this xlBOM with thumbnails - Blue Byte Systems, Inc.
It has feature that will export large thumbnails of all BOM rows into a folder of your choice. The thumbnails will have the same name as their referenced models.
Best,AmenSOLIDWORKS PDM API Programming services
Thank you, but it costs 250 USD . looking for freeware.
I don't think there is a freeware that does that.
Retrieving data ...