0 Replies Latest reply on Jun 6, 2017 2:56 PM by Michael Ferraro

    Creating a Collection

    Michael Ferraro

      All,

       

      I would like to create a module in VBA that parses through an assembly to find specific parts based on a custom property.

       

      I have heard that creating collections is a much faster choice when dealing with very large models, but I have never worked with collections before. Is it essentially like a table?

      What I would like to do is collect all the parts/assemblies in the assembly that is currently open and get the custom property "Component ID" for each part/assembly.

       

      What I am looking to do is spit out the file name for each component ID into an excel cell.

       

      So the File Name for ID 1 goes in Cell M2, ID 2 goes in Cell M3, etc.

       

      Thanks,

      Pencil