hello everyone,

I need your help to extract (and display) the name of the material of each components from an assembly on an excel file. Currently, we succeed to extract different data for each component like the mass, volume, density  ect.. and display them on an Excel file. Currently I have succeed to extract the material from a part document ONLY in an other macro ( I attach it in the post ("material")). But when I add this macro in my "macro final" (for an assembly), it doesn't works...

That I would :

I would that someone help me to add some lines in my "macro final" which allow to extract the material of EACH components from the active assembly.

Thank you in advance for your help.

AUBERT Romain.