AnsweredAssumed Answered

Creating a Collection

Question asked by Michael Ferraro on Jun 6, 2017



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.