Register Properties of all parts or sub-assemblies using Excel base macro

Hi guys,

new here,

i just like to know if you have any idea how to register or apply the properties of all parts or sub-assemblies in an assembly.

What I do is select the part "one at a time" to apply the properties using the Property Tab Builder

What I like to do now is input the properties like part name, description drawing no. etc. in excel base

So when I apply the properties for all parts it is very much faster and easy.

its like every cell in the excel sheet is link to a particular property.

and then you will hit apply button to register all the properties to each parts.

I hope it makes sense.

Thank you

SolidworksAssemblies