CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor, Revit and other Autodesk products [www.cadforum.cz]

CAD tip # 11732:

Question

CAD
% platform category

How to sort BOM or parts list by part number in Inventor? (iLogic)

You can change sort order of your parts list in an Inventor drawing using the following simple iLogic rule - it re-sorts the partlist so that its individual items (rows) are listed in ascending order their part number.

The re-sorted parts list can be then renumbered starting by 1.

On Error Resume Next
Dim oDwgDoc As DrawingDocument
oDwgDoc = ThisApplication.ActiveDocument

Dim oPartsList1 As PartsList
oPartsList1 = oDwgDoc.ActiveSheet.PartsLists.Item(1)
If oPartsList1 Is Nothing Then
	MsgBox ("No parts list!")
Else
	oPartsList1.Sort("PART NUMBER") ' Needs to be localized: e.g. BAUTEILNUMMER (de), ČÍSLO SOUČÁSTI (cz)
	oPartsList1.Renumber
End If

If you need to change sort order of your assembly BOM in a similar way, use the following iLogic rule:

'Get active assembly
Dim activeAssembly As AssemblyDocument = ThisApplication.ActiveDocument
'Get structured bom view
Dim bomView As BOMView = activeAssembly.ComponentDefinition.BOM.BOMViews(2)
'Sort by Part Number
Call bomView.Sort("Part Number", True)
'Renumber rows
Call bomView.Renumber(1, 1)

Inventor

* CAD

14.12.2017 4786×

Comments Tell a friend

Prices - CAD eShop:

Inventor

Product Design Collection

applies to: Inventor ·

See also:
Tip 12392:	Export unfolds of sheetmetal parts to DXF - parameters for iLogic and VBA
Tip 12317:	How to publish a custom iPart to CC with Color as one of its parameters?
Tip 12046:	Random shape and appearance of an Inventor part or assembly.
Tip 11886:	STEP file from ProE is loaded into Inventor with part numbers, not names.
Tip 11883:	How to quickly locate (and run) a specific command in Revit?

Selected tip: How to import a Word document into AutoCAD and keep it linked (like xref)?

Back All CAD Tips

How to enter the symbol № (numero) in AutoCAD? « | » Select objects by annotation scale.

Have we helped you? If you want to support the CAD Forum web service, consider buying one of our CAD applications, or our custom software development offerings, or donating via PayPal (see above). You may also add a link to your web - like this "fan" link:

CAD: OS: Categ:
Text:	FAQ glossary

Featuring:
Track your time spent working on AutoCAD or Revit jobs - automatically with
CADstudio JobTime More info

Please use these tips at your own risk.
CAD Studio is not responsible for possible problems that may occur as a result of using any of these tips.


Login/Register:
Visitors: 1055