I have an assembly with various parts. Parts are in different sub-assembly levels. Parts have different materials. Is there a macro that change material of each part in an open assembly based on Excel or TXT input file. For example Input file would look like this.

Basically when the macro is run it should find parts in the current assembly, look for what the new material should be for that part based on input file (excel or txt) by matching the part file name from the list and assign it. Repeat this process until new materials are assigned to each part in open assembly. Assigned materials will be different for different parts as shown in table above.