I got an Macro for extracting info out of each component in the top level of the assembly and write this to an excel. the macro works for 95% but it still has an error in it. if the quantity of a component is more then 1 it makes a row for each quanity. so if the quanity is 4 is makes for row and display 1, 2, 3 and 4 individual in each row. below is the macro and below there is an example of the