Adding values from within a BOM

[Anonymous]

Hello All,

        I have a basic assembly with a few kitchen cabinets. I would like to total up the length of my moulding and have the waste included. Can someone point me in the right direction on how to go about this. Is it possible to do this within Autodesk Inventor without exporting it to excell? Thank you

[ekinsb]

A VBA macro can be written to do this.  I can write up a small sample but need to know how you identify which parts are molding parts.  For example, is there something common in the part number or the description?  Also, once you've found a molding part, how do you know how long it is.  Is there a parameter that defines the length?  If so, does it have a consistent name?  And finally, how do you determine waste?

[Anonymous]

Thank you for your reply,

Is there something common in the part number or the description?

Each description will have the company and profile #. example  (Old World_1074-01),(White River_CR-881-01) these are iparts. The suffix will be added as we place new parts into the assembly. (-01, -02, -03)

Is there a parameter that defines the length?  If so, does it have a consistent name

I have a property field called (Length) that generates the display of the value.

How do you determine waste?

example: add 30% to total linear footage

We would like Inventor to total all the length fields for each moulding and add 30% to get out total.

Thank you again for your time

[Anonymous]

I will add the word molding in the catagory iproperties for each molding ipart. This will help group the molding as needed.

[ekinsb]

I've tried to answer your question in the latest post on my blog.  http://modthemachine.typepad.com/my_weblog/2010/09/totaling-the-length-of-parts-in-an-assembly.html  Hopefully it helps.

[Anonymous]

The post looks great, Thank you for your time

I am trying to implement this script, however I am receiving a error.

Run-time error '13':

Type mismatch

' Main program that computes the total length of all molding
' parts in the active assembly.
Public Sub ComputeMoldingLength()
   Dim asmDoc As AssemblyDocument
   Set asmDoc = ThisApplication.ActiveDocument
   Dim asmDef As AssemblyComponentDefinition
   Set asmDef = asmDoc.ComponentDefinition

The line above in red is highlighted in yellow.

I am doing this in a Inventor DWG file, is that correct?or should I be doing this in a IAM file?
 

[Anonymous]

Void last post

It works fine, thak you very much