Getting component's name when used more than once in sub-assemblies

Hi everyone,

I have a main assembly that contains 2 sub-assemblies. Each one of these sub-assemblies contains the same component among others. I would like to get the name of that component so that I can suppress it or not depending on the design, or selecting one of its configurations. I like to use the GetComponentByName command for ease of my excel VBA program reading. For some reason, I am not able to get the name correctly. I have tried "component's name-instance@sub-assembly's name-instance" in the GetComponentByName command without any success. Same thing for sub-assembly's name-instance/component's name-instance... I realized that when the component is assembled only once in the whole assembly (no matter where...but only once!), I can get the component's name withe a basic GetComponentByName ("component's name-instance").

Anybody could help me?

SolidworksApi macros