apply custom properties of every component

Hi guys

new here

i hope someone can help me

In an assembly, I input every component/part properties using property tab builder selecting "one at a time"

What like to do is input the properties using a excel base macro/API to fill up the cells "at the same time"

I hope it makes sense.

Cheers,

SolidworksApi macros