Help with BOM's
Help with BOM's
(OP)
Hello everyone,
Does anyone know how to export a bill of materials to an excel file? I looked in help and it told me this:
Click the bill of materials on the drawing sheet.
1. Click File, Save As.
2. The Save as type is set to Excel Files (*.xls) by default.
3. Enter a file name, and click Save.
You can use the saved bill of materials in Excel, or as an OLE object in other applications. The saved file is not linked to the bill of materials in the drawing; edits to one do not affect the other.
After reading the above instructions I did it as follows, but when I try to save as a (*.xls) file the option is not there in the pull down menu.
Do I have to do something else before saving?
Does anyone know how to export a bill of materials to an excel file? I looked in help and it told me this:
Click the bill of materials on the drawing sheet.
1. Click File, Save As.
2. The Save as type is set to Excel Files (*.xls) by default.
3. Enter a file name, and click Save.
You can use the saved bill of materials in Excel, or as an OLE object in other applications. The saved file is not linked to the bill of materials in the drawing; edits to one do not affect the other.
After reading the above instructions I did it as follows, but when I try to save as a (*.xls) file the option is not there in the pull down menu.
Do I have to do something else before saving?
A man should look for what is, and not for what he thinks should be. -Albert Einstein
A person who never made a mistake never tried anything new. -Albert Einstein






RE: Help with BOM's
RE: Help with BOM's
How do I create an excel-based BOM? And what is the purpose of having two different BOM's?
A man should look for what is, and not for what he thinks should be. -Albert Einstein
A person who never made a mistake never tried anything new. -Albert Einstein
RE: Help with BOM's
Note ... you cannot have both types of BOM in a drawing set.
SW created its own BOM for people who do not have or want excel on their computers & to make it more user friendly????
Also note ... the .csv & .txt files created from the SW BOMs can be opened in Excel.
RE: Help with BOM's
Can the excel based BOM be automatically updated or do you have to always re-save the information each time it is updated?
I guess if it has to re-saved each time I could try to create a macro to handle that.
A man should look for what is, and not for what he thinks should be. -Albert Einstein
A person who never made a mistake never tried anything new. -Albert Einstein
RE: Help with BOM's