BOM - Select all

[PACDrafting]

Hi

If a user opens a BOM. What is the command to select all?

I will be writing some code to after this select all is run. It then copies the selection, opens excel and pastes into excel.

This is due to the fact that we only want the user to expand the assemblies that are required to be in the BOM. e.g. an off the shelf purchase of a cylinder does not require all parts to be purchased, only the cylinder itself.

Another option is replace the assembly of the cylinder as a derived part file, but this will not allow driving constraints. So this will not work.

Our customer is not using Item Master unfortunately.

Thanks for any help

Paul

[MechMachineMan · Accepted solution]

Isn't this case what making the parent purchased BOM Structure, and the sub-components either purchased or phantom BOM Structure is intended for?

[Owner2229]

I don't know about the selection, but here's how to export BOM "directly":

Dim oDoc As AssemblyDocument = ThisApplication.ActiveDocument

' Set a reference to the BOM
Dim oBOM As BOM = oDoc.ComponentDefinition.BOM

' Set the structured view to 'all levels'
oBOM.StructuredViewFirstLevelOnly = False

' Make sure that the structured view is enabled
oBOM.StructuredViewEnabled = True

' Set a reference to the "Structured" BOMView
Dim oStructuredBOMView As BOMView = oBOM.BOMViews.Item("Structured")

' Export the BOM view to an Excel file
oStructuredBOMView.Export("C:\temp\BOM-StructuredAllLevels.xls", FileFormatEnum.kMicrosoftExcelFormat)

' Another option - to export parts only:

' Make sure that the parts only view is enabled
oBOM.PartsOnlyViewEnabled = True

' Set a reference to the "Parts Only" BOMView
Dim oPartsOnlyBOMView As BOMView = oBOM.BOMViews.Item("Parts Only")

' Export the BOM view to an Excel file
oPartsOnlyBOMView.Export("C:\temp\BOM-PartsOnly.xls", FileFormatEnum.kMicrosoftExcelFormat)

[PACDrafting]

Your right thanks Justin

Changing the subcomponents to Phantom removes them from the sub assembly