How do I save a SolidWorks generated BOM as an Excel file?
Excel-based BOMs: Single click on the BOM so it is selected, and then go to File - Save As. Do not double-click to activate the BOM since it cannot be saved when active.
Table-based BOMs: (SolidWorks 2004 - SolidWorks 2006) Single click on the BOM so it is selected, and then go to File - Save As (or right-click on the BOM and choose Save Template). Select save as file type Text (*.txt). Then, Browse to the saved TXT file using Windows Explorer. Right-mouse click on the TXT file and choose Open With - Microsoft Office Excel.
Table-based BOMs: (SolidWorks 2007) Single click on the BOM so it is selected, and then go to File - Save As (or right-click on the BOM and choose Save As...). Select save as file type Excel (*.xls).
