automatic bom to excel capability

[Nel_Zelpher]

My company likes to extract the bom from inventor to a separate excel spread sheet. I want an automatic way to export that bom to an external file.  How do I do this?

Now I know in autocad, that when you have a data extraction generated table in the drawing that AutoCAD automatically ask for that table to be updated every time you try to print.  And if you have your settings right autocad will also cut a new excell file for you at the same time.  But how do you do it in inventor?

[johnsonshiue]

Hi! Out-of-box, you can export it in BOM dialog manually. Or, you can use iLogic or Inventor API to automate the process. Here is a list of BOM related apps on App store. Some of them seem to be able to automate the process.

https://apps.autodesk.com/INVNTOR/en/List/Search?isAppSearch=True&searchboxstore=INVNTOR&facet=&coll...

Many thanks!

[A.Acheson]

Are you wanting to export the partslist from the drawing or the BOM from the assy? These are different exports and it would be good to know which you use at the moment. The exports can be both done manually as well as automatically by coding through ilogic/VBA etc. 

BOM:
I assume you are using the manual export button at the moment but want to automate the excel file location and maybe the template it goes into yes? I would say an iLogic export rule on save event trigger would work. Do you like to have only a few columns exported or to see the entire BOM exactly as in inventor?  

Do you have a sample BOM showing the columns you typically export? Also do you run any post processing in excel afterwords, sorting by category? If you do you could  incorporate this processing in the same rule. 

How much experience do you have with VBA/iLogic programming?

[Nel_Zelpher]

than you I will look at this solution.