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.
SolidworksApi/macros