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.