Export Inventor Parts List with Thumbnails

Parts10

It is easy to export a parts list or a BOM to Excel from Inventor. A parts list with thumbnails from Inventor into Excel, not so much. It seems there is NO straight forward method that can be used to export the thumbnails into Excel since Excel does not support embedded images in a cell.

I have found an option for Word that works rather well which I will address momentarily. As for Excel, there are a few options although for a fee.

If you click on the Autodesk Exchange App icon in the upper right in your Inventor program it will bring you to the App website.  parts1Type BOM into the search bar and press search.Parts2

 

 

The top four results are programs that say they can export the BOM or Parts List to Excel along with thumbnails. I have played around with BOM Tools Pro and can report that it works pretty well. It is not too hard to use and you can configure it to a degree. The only other one that I looked into is iBOM. I watched the video and read some of the reviews. It looks like it has the ability to fill many of the needs for which many people are looking.

I found a very nice alternative that is free, has been around for 6 years and works well with the output in Word. Posted in 2010 by Brian Ekins & Adam Nagy from Mod the Machine.

I was a bit skeptical that a solution from 2010 would still work with a 2017 Inventor program and model so I followed the article directions, downloaded the VBA code and ran the Macro. Poof, it worked great. Below is a quick recap of how the program works.

After reading the Mod the Machine article, I copied the VBA source code to my clipboard.

In Inventor I opened the VBA editor located on the Options panel under the Tools tab.

In the Editor, select File, New Project. Click on the new project, UserProject1, which was added to the Projects list, click Modules then double click Module 1.

Parts3Parts4

Click inside the new module window and paste the source code that you copied to the clipboard. Save the Project to a known location that you will go back to load the project if you want to run it again in the future. In my case I named the file PartsListWithThumbnailImage.

Parts5

There is one more thing to do before we go to our drawing. In the Visual Basic Editor, select References under the Tools tab.Parts6

The program uses Word and you need to add the reference to the Word Object Library. Yours may differ, mine happens to be Microsoft Word 15.0 Object Library so check the reference that applies to the version of Word you are using. Click OK and close the window.

Parts7

Now you can open a drawing. You must click on the Parts List so that it is active. The parts list will show green.Parts8

Since the code is loaded into the VBA Editor you can go to the Tools tab and select the Macros button on the Options panel. Your macro should appear in the list of available macros. Select CreatePartsListWithThumbnail from the list and select Run.Parts9

Below is a partial view of the Word doc of my parts list with thumbnails.Parts10

There you have it. Works well with Inventor 2017 and if you can live with a Word document, it may fit your needs. I am always amazed at the information available. That so many people put in a good amount of time to produce apps and programs to help the rest of use accomplish our work. Thanks again Brian & Adam!

I hope this helps to ease your work load!

Till Later,

Dave

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s