Posted on 26 Comments

Export SOLIDWORKS BOM to Excel with thumbnail preview – SOLIDWORKS MACRO

Create SOLIDWORKS BOM with thumbnail preview


This macro has been converted into an add-in.
Source code:
Download:  Available on the release page of the GitHub repository

  1. This macro exports a selected SOLIDWORKS BOM to Excel.
    A thumbnail preview is created for each of the BOM components.
  2. You must have Excel installed.
  3. This macro works with parts-only BOM.

Problems running the macro? Report a bug here.

26 thoughts on “Export SOLIDWORKS BOM to Excel with thumbnail preview – SOLIDWORKS MACRO

  1. Hello, Mr. Amen,

    first of all I would like to say briefly that I am glad that there are such persons as you. I am very interested in your solution regarding the parts list with preview. If all this works with the BOM I will try your PDM solution. Is it possible to get step by step instructions for the parts list? I always get an error message (You have not selected any bill of materials). I’d love to get it done, but I’m not getting any further. I’m always grateful for help.

    With kind regards

    Ilyas Zorla

    1. Thanks for your comment Ilyas. I appreciate your interaction.
      If you are getting that message, it means that you have not selected a bill of materials.
      Follow these steps:
      – Open you SOLIDWORKS assembly document
      – Insert a bill of materials
      – Select the bill of materials in the three 3D space
      – Run the macro

      1. Thank you Amen for the quick help.
        I have tested it and I am excited how easy it is and how well it works.
        Thank you very much for your support. Now you’ve got one more fan.
        Keep up the good work

        1. Thanks Ilyas Zorla!

  2. Hello Amen,

    This script works very well and as intended for assemblies with a small number of parts (less than 30 to 40) but for an assembly with larger number of parts I’m having Solid Works crash. I had a hunch and it seems that Solid Works is hitting the GDI limit of 10k. I can up the limit to about 16k but that will only delay the crash. It seems that when opening and closing each part the GDI keeps climbing and is not being let go after each part is closed.

    Any way to make this work on larger assemblies? Ideas?


    Gord Evans

  3. Hi
    There is error in this line!
    Set swTableAnnotation = swSelectionManager.GetSelectedObject6(i, -1)
    Macro is not working?!


  4. Hi Amen,

    Thanks for your code it works fine and generate image preview in excel sheet but saving the excel sheet i can only see the latest thumbnail image in all the rows, Any suggestions ?

    1. Can you check the temporary folder and see if the images all get saved there.

      1. I have the same issue. It only saves the last reverenced thumbnail. I believe that the code overwrites the previous image, and doesn’t create a new one. Any suggestions on how to modify the code so that it creates a new unique file name?

        1. Can you try running your SOLIDWORKS with administrator privileges?

          1. Even when I run it as an administrator, it still only remembers the last image. When I look in the temp folder for the image, it only has one file there isn’t a temp image with multiple numbers, so when the Excel file is opened after saving it references that single image and only shows that thumbnail.

            When you run the Marco it works and shows all the images, its just when you save it and reopen it, that it shows the last thumbnail.

          2. Ben,
            I think that is an excel problem. The only way I see this being fixed is through a SOLIDWORKS add-in.

        2. I have solution for this problem.

  5. I have tried to use this macro. I have run into a few problems. If I run it from the assembly, it exports the BOM but with no thumbnails. If I run it from the drawing of the assembly it only exports a few of the thumbnail.

    Any suggestions would be appreciated.

  6. Thank Amen

    whats about assemblies components ?


  7. Amen,

    you are the best. Thank you very much for this marvellous work. I have learned a lot from your code, also how to handle an Excel document.

    Cheers, Miro

  8. Can you make it close the part file when its finished with the part entry? Mine crashes around 20 parts after solidworks runs out of resources.

    1. Yep, mine also crashes, it would be a great amendment

  9. Dear Amen
    I am using SW 2016 SP5 and excel 2016 when I operate the macro it is not working and it shows a message: “run-time error ‘424’ object required”, and in the visual basic for applications line 59 in the code in marked ( If swSelectionManager.GetSelectedObjectType3(i, -1) = swConst.swSelectType_e.swSelANNOTATIONTABLES Then)…..
    can you help me fix the problem?
    Thanks in advance,

  10. Hi Amen,
    Many thanks for your macro. Unfortunately I´m at the same situation of most of us.
    The solidworks crash after running the macro for the first 20 to 30 parts.

    Can you let us know if there is any solution? or better start to write the macro from the 0.
    Again many thanks for your help.
    Best regards.

  11. Thank you sir for this awesome macro…

  12. Perfect Thanks Man

  13. Greetings Amen,

    First of all I would like to thank you for providing this awesome Macro, it really rocks.
    But unfortunately i am facing the same issue as the others. After aproximetly 30 (sometimes 38) items perfectly linked to excel BOM, my SW always collapses. Is there any possibility, how to avoid this unpleasant situation?

    Thank you for your respond.

    1. Please use the add-in posted on the article header.

  14. Hi
    Thanks for the program. Some of the items when exported show as N/A on the excel spreddsheet. Excel 2010

    1. What are you using: the add-in or the macro?

Leave a Reply

Your email address will not be published. Required fields are marked *