Hi, I have a query about an assembly design table: ¿Is it possible to determine in the excel table, the quantitty a part is present in the assembly? Because I need to export that excel file and then link it to the assembly, to determine the costs directly and updated. Thanks!.
Hi Dennis, thanks for your reply. I understand, but is it possible to export the BOM and link it to an excel file?
You can get the quantity of all your parts in an assembly using a Bill Of Material (BOM) table. You can export that to Excel.
I understand that I can export the bill of materials to Excel, but it is not linked, i.e. if you modify the assembly without automatic changes to the Excel file. My query was original: Is there a way to get a permanent link between the assembly and an excel file?
Marcelo Bisciglia wrote:
I understand that I can export the bill of materials to Excel, but it is not linked, i.e. if you modify the assembly without automatic changes to the Excel file. My query was original: Is there a way to get a permanent link between the assembly and an excel file?
I understand now the full extent of what you want.
The direct answer is I do not think you can create a dynamic link as you request. Even if you could SWX would have to open and update the assembly in order for any changes to show up in the link, so there isn't much of an advantage.
I am no macro expert, perhaps Artem Taturevych can help. Possibly you could have a macro that auto-runs when an assembly is opened, checking to see if its BOM has changed and if so export a new version, perhaps including a date code or incremental revision number. But then, you would also have to know to check the assembly.
As I think more about what you are asking I am now questioning its value. When you "officially" release or change an assembly or its parts is when the BOM would need to be updated. For development work the changes could be so rapid that this information would not be of value, at least I don't see it. For an official release it should already be part of the procedure to check and update the BOM and document it.
Just to be precise. The YT video is for a BOM from a drawing, not from an assembly file. I do not know if this matters, but It was only a few years ago that SWX even gave us the capability to do a BOM in an assembly file. Prior to that we could only do them in a drawing.
As far as the linking goes the technique shown is obviously simple and straightforward. You should try it and see if it delivers everything you want. I am curious as to what happens when you make changes to your assembly and therefore to the BOM, close SWX, and then open the Excel file linked to the BOM. Maybe it says something that it needs to update. I don't know what will happen.
You can get the quantity of all your parts in an assembly using a Bill Of Material (BOM) table. You can export that to Excel.
An assembly design table does not serve that purpose, it is for controlling suppression states, dimensions, and configurations of the parts, but does not control nor "report" the quantities.