Parts list form automation

Parts list form automation

psw1125
Advocate Advocate
342 Views
3 Replies
Message 1 of 4

Parts list form automation

psw1125
Advocate
Advocate

When I create a parts list, I always export the BOM list from the assembly drawing.
Then I edit the exported list to create the parts list form.
Is there a way to automatically fill out an existing excel form?
Or can you help me how to automate this process using iLogic?

0 Likes
343 Views
3 Replies
Replies (3)
Message 2 of 4

admaiora
Mentor
Mentor

You can find some material here:

 

https://knowledge.autodesk.com/support/inventor/learn-explore/caas/CloudHelp/cloudhelp/2018/ENU/Inve...

 

https://knowledge.autodesk.com/support/inventor/learn-explore/caas/CloudHelp/cloudhelp/2018/ENU/Inve...

Admaiora
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.

_____________________________________________________________________________
Facebook | Twitter | Youtube

0 Likes
Message 3 of 4

WCrihfield
Mentor
Mentor

Your use of the word "drawing" in that first sentence may be a bit misleading.  When you say you always "export the BOM list from the assembly drawing", are you talking about the actual assembly model file's BOM or are you talking about a Parts List in the drawing file that is representing the assembly in its views?  Then I assume it is exported as an Excel file, right?  Also you use of the term "form" is confusing to me.  Do you mean that you leave the title and column headings of that exported data, but get rid of all the data in the other cells, so that it must all be somehow filled in after you insert it into the drawing as a Parts List?  Or have you developed a VBA UserForm in Excel's VBA Editor that you want to use to fill in Parts List data?  If we were to create code to fill data into cells in an Excel file, we would need to know the full path & name of the Excel file, the sheet/tab name, how everything is laid out on that sheet, so we know where to put the data, and what all data we will be putting into each of those cells.  It is potentially fairly complicated to do it that way, depending on your needs.  I don't think you can specify a 'Template' to export an assembly model BOM by, but I do believe you can specify a 'Template' file so use when exporting a drawing's PartsList out.  Maybe that could somehow work for your process.

Wesley Crihfield

EESignature

(Not an Autodesk Employee)

0 Likes
Message 4 of 4

fidel.makatiaD5W7V
Alumni
Alumni

Hi @psw1125  you can also read how to export BOM in inventor 2022 official docs here

Inventor 2022 Help | Exporting the assembly BOM | Autodesk



Fidel Makatia
Developer Advocate

href=https://help.autodesk.com/view/INVNTOR/2022/ENU/?guid=GUID-0BD48573-7193-4285-87B7-6727555D053E rel= "noopener noreferrer">Inventor 2022 Documentation |
0 Likes