AnsweredAssumed Answered

Make assembly traverse skip all sub assembly components only when parent is excluded from BOM.

Question asked by Josh Hixon on Jul 16, 2018
Latest reply on Jul 16, 2018 by Nilesh Patel

I am really excited about this macro I have been working on, it is traversing the assembly and compiling a BOM with Raw material numbers (custom property) or part numbers based on a few conditions, and for quantity either pulling cutlist total length in feet or a number of times the component is used in the assembly. A few things left to do with this, adding all like raw materials up instead of writing new lines and telling it to save as a comma delimited CSV for our inventory management software to import. (saving the easy thing for the very end, like dessert after a healthy helping of veggies.)


But I just found a big problem, I have it set to do nothing for suppressed or Excluded items, the problem is when excluding it only excludes at the top level, so because the traverse is using an array that gets all child components of subassemblies, I am getting the parts from excluded subassemblies. Short of excluding all subassembly parts, or deleting unused subassemblies, any thoughts on how to address this issue?


Here is what I have so far in this macro. It is messy I know. Literally learning Visual Basic as I go on this macro, it uses a lot of bits from other macros here on the forums.