Using BOM to export to pre-existing excel sheet

[Jordon.Oldham]

Hi,

I'm trying to use iLogic to use my BOM that has all my correct part names and use it to fill in a pre-existing Excel sheet we use for manufacturing releases. 

My hope is that I can run iLogic to do this rather than having to copy and paste several hundred lines in and making things automated to streamline my release progress.

any help is greatly appreciated!

thanks all!

[A.Acheson]

Hi @Jordon.Oldham 

Are you exporting the BOM from the model or partlist from the drawing? Can you supply the code you allready using? 

As you can see in the 2024 BOM Export object we have the option to export data to a specific sheet however this will likely overwrite the data on that sheet.

BOMView.Export( FileName As String, FileFormat As FileFormatEnum, [Options] As Variant )

A workaround to this limitation is to export to a temporary excel file and copy by code the data over to your template workbook.

Can you share where your putting the data and what it will look like once processed? You should be able to automate all the manual processing your currently doing. I would suggest to start with a list of those steps. 

[Jordon.Oldham]

Hi there!

thank you for the reply.
I'm trying to export from the parts list at the moment, would you recommend the BOM instead?

I currently don't have any code, I'm quite new to iLogic so I'm learning as I go.
Our excel I am trying to export to is rather complex, so overwriting may not be a good idea. Would i be better creating a slimmed down version of the spreadsheet and trying to export to that?

many thanks!

[Curtis_Waguespack]

---

@Jordon.Oldham wrote:

I'm trying to export from the parts list at the moment, would you recommend the BOM instead?

---

Hi @Jordon.Oldham 

See this link for an example of exporting a parts list using a template:

http://inventortrenches.blogspot.com/2011/06/ilogic-export-parts-list-with-options.html

See this for a BOM example provided by A.Acheson in the past:

https://forums.autodesk.com/t5/inventor-ilogic-and-vb-net-forum/ilogic-to-export-bom-from-assembly-t...

I hope this helps.
Best of luck to you in all of your Inventor pursuits,
Curtis
http://inventortrenches.blogspot.com

[A.Acheson]

Which route you take will depend on what your current workflow is now manually. The Partslist has more options that you can set by code. 

The BOM export is very limited and most customization needs to take place after the BOM has been exported to excel. This would be moving the data around, deleting extra columns, reorganizing columns etc.

If you always have a drawing done then the Partlist could be the best fit. If you don't show all the parts on the Partlist but they are all in the BOM then the BOM could be a better fit.