AnsweredAssumed Answered

Export the created and selected Assembly (.sldas) BOM to Excel using .SaveAsExcelFile

Question asked by Jeff Woodall on Nov 12, 2019
Latest reply on Nov 12, 2019 by Artem Taturevych

I have compiled a Macro that (requires and open Assembly file) creates a BOM in the assembly using a specific BOM Template, and places it in the assembly file. It next selects the BOM table, but from there I can not save to Excel using the API. I would like to simply save to excel file they way you can if you RMB on the Bill of Material in the feature tree under Tables. I want to do this so that I can quickly access all of the assembly files in a given folder and have them automatically create and save the BOM.

I think that I can traverse the BOM and pull the data over to Excel, but I should have to, if I can simply do a save as.

 

Thank you.

Outcomes