Parts List Array Manipulation

[cameron.houston]

Hi All,

I am creating a button that gives parts listed in multiple  parts list (ie same part used in multiple weldments that have separate boms) the same item number. In order to do this I have each parts list row being compared to all the rest of the parts list rows in order to see if there is a duplicate. My issue is because I have parts list on different sheets, when I am comparing one row  of a given parts list I have to loop through all the sheets and all the parts list on each sheet comparing values. this results in a lot of looping that ultimately slows down the button. I would like to at the begging on the code go through and "combine" all the parts list into one jumbo parts list array that I  could then interface with without having to do so many loops. My question is can this be done? Can you work with parts list like arrays directly? or do I have to build my own array of parts list values?

Thanks,

Cameron

[rhasell]

Hi

Not that I can help with the problem, but I can make a suggestion of creating a dummy Assembly containing all the parts and sub assemblies in order to populate a "Master/Jumbo" BOM

This can then be referenced in your code?

Doing this might change the direction of your requirement, you could then create a custom property in the BOM, allocating a unique item number to each part. This can then be linked to some code, and also called up in the drawings, assigning the custom item number to each part.

The caveat of this, is that common parts will change their item numbers depending on various projects. So you will have to bear this in mind and adjust accordingly.