BOM to Excel macro, BOM type: part only

Macro
,
1

I got a macro in these pages, it works very well, except for a small thing. The subassemblies included in the assembly I want to extract appear and I don't want them. I think the correction to be made is here:

' The nomenclature model is defined
TemplateName = "\\server-hv\BE\- Library\- SW2015 Configuration\BOMs\Nom_3-2_19-06.sldbomtbt"
BomType = swBomType_Indented
   

How do I change the "swBomType_indented" so that the extraction contains only the parts and not the sub-assemblies?

Thank you

2

Hello. Try:

BomType = swBomType_e.swBomType_PartsOnly
ou
BomType = swBomType_e.swBomType_TopLevelOnly

 

1 Like
3

Impeccable, the "swBomType_e.swBomType_partOnly" works.

Thank you