Join Gabriel Corbett for an in-depth discussion in this video Creating build materials from SOLIDWORKS Explorer, part of SOLIDWORKS: Tips & Tricks.
- [Instructor] For this week's tip, I'm going to be showing you to click. For this weeks' tip, I'm going to be showing you how to create a quick bill of materials from inside of SOLIDWORKS Explorer. Now if you go into SOLIDWORKS Explorer you can see you can just go to any one of your different folders and in this case here I'm in this T26 folder and I've got several different parts plus an assembly there and I'm going to create a bill of material of these parts. Now this can be a multi-level bill of materials with all kinds of different parts, sub-assemblies and so on and it works exactly the same. But I'm just going to start with a pretty small subset of parts and assemblies and go from there.
So anyways, get into the folder you're looking for, click on the assembly row, any of the parts, basically the whole folder and then come up here to the second icon over which is called save to file. Click on that one and I'm going to put it here. I'm going to overwrite the file called FielList.txt. Click on Save, go ahead and override it if you already have it in there and then jump over to Excel and you can see here I already have this file opened up and you can see exactly what's in here. So inside of Excel, I've got the individual parts. Here's the assembly, the size, what type of document it is, when it was last modified, attributes and where the full path is to where that's located in your system.
So it's a pretty handy way to just quickly create a bill of materials which then you can actually send out to a customer or send to your vendors, send to your purchasing department, lot of different things you can do. I would say even create a bill of materials inside of our drawings as well but this is a great way to quickly get it into Excel, right from SOLIDWORKS Explorer. Hopefully this helps you out and check back next week for more tips and tricks. Thanks so much.