CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor and other Autodesk products [www.cadforum.cz]
Cesky English Deutsch
Login/Register:
 Visitors: 1413 

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  
Next  
Next  
Next  
Next
 
Inventor
100% *  CAD 
21.8.2012    1731x  
Comments   Tell a friend
applies to: Inventor ·

See also:
Tip 9672:How to display multiple types of parts lists in Inventor drawings?
Tip 9532:How to split Inventor parts lists to multiple sheets?
Tip 9528:Using Autodesk Fusion 360 as a CAD converter.
Tip 9102:How to display miter values in Inventor BOM?
Tip 8927:How to exclude parts of the Inventor assembly from total mass?


Back   All CAD Tips All CAD tips&tricks

Silent installation of Windows applications - MSIEXEC parameters « | » How to get and install a localization for Revit 2013?

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   



Featuring:
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.
CAD Studio (Xanadu) is not responsible for possible problems that may occur as a result of using any of these tips.
TOPlist