Just trying my luck here. I'm currently using #Task to export multiple BOMs from a large number of SLDASM files. This produces over 300 individual excel BOM files for me, which is great, however it would be even better if this data was consolidated into one excel file. Is it possible to save mass BOM data out into an existing Excel file?
If this doesn't work, then perhaps I'll search for a macro to combine multiple excel workbooks together.