CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor, Revit and other Autodesk products []
CZ | EN | DE
Login or
  Visitors: 2516

CAD tip CAD tip # 8767:

Question CAD 
 %  platform  category 
Q - question

How to change all partslist cells to non-static?

A - answer If you have overwritten values of some cells in Inventor partslist, these values are "static" - they do not recalculate. When you want to change them back to recalculated cells, you can use the following VBA macro (you can also use it in iLogic):

Dim drawing As DrawingDocument  
Dim sheet As Sheet  
Dim pList As PartsList  
Dim pListRow As PartsListRow  
Dim pListCell As PartsListCell  
Dim cellIndex As Integer  
drawing = ThisApplication.ActiveDocument  
For Each sheet In drawing.Sheets  
For Each pList In sheet.PartsLists  
For Each pListRow In pList.PartsListRows  
For cellIndex = 1 To pList.PartsListColumns.count  
pListCell = pListRow.Item(cellIndex)  
pListCell.Static = False  
100% *  CAD 
21.8.2012    7560×  
Prices - CAD eShop:
applies to: Inventor ·

See also:
Tip 13227:Reference Explorer - quick analysis of your project or assembly (file size, xref errors).
Tip 12392:Export unfolds of sheetmetal parts to DXF - parameters for iLogic and VBA
Tip 12046:Random shape and appearance of an Inventor part or assembly.
Tip 11868:Open just a part of a DWG drawing - layers, views.
Tip 11732:How to sort BOM or parts list by part number in Inventor? (iLogic)

Back   All CAD Tips

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 Forum - tips, utilities, blocks for Autodesk products
CAD:    OS:    Categ: 
Text:  FAQ glossary   

Link your AutoCAD block attributes with Excel tables/sheets. Automatically. Dynamically. Bidirectionally.
Try Excellink 2015 More info

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