edit excel based bom template
edit excel based bom template
(OP)
Trying to find out how to edit the excel bom template to include a column for Solidworks folder name so that I can keep track of the locations of all parts in an assembly (w/out opening SW). What needs to be typed in the Name Box in Excel to get this to work? For example, for part numbers you have to have partno in Name Box, however I'm not sure where this is pulled from in solidworks - my part number in properties is PartNumber






RE: edit excel based bom template
RE: edit excel based bom template
The first shows the typical SW table with a column for folder name added and the locations are generated. For an Excel based BOM you start one from a template. However, the supplied templates aren't very tailored (no folder name). I want one similar to the SW BOM but with the advantage of it being external. Need the proper syntax for writing in Excel so that the folder locations will populate automatically.
RE: edit excel based bom template
Edit List on Property tab.
Add SWFolderName.
In Value/Text Expression add - $PRP:"SW-Folder Name" . (if you can find a way to add this to the list it would be a big help)
The Evaluated Value should show your file path.
Make a copy of the BOM that you want to change in Excel and rename.
Add a column in the appropriate place to the left of $$END.
At the top of the column type in your header.
Click on this cell, go to the Formulas ribbon, click on Define Name.
Type SWFolderName (no spaces or hyphens)
RE: edit excel based bom template
Thanks!
RE: edit excel based bom template