AnsweredAssumed Answered

Changing material of parts in an assembly based on Excel or TXT file.

Question asked by Mehmood Ahmed on Feb 5, 2020

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.

 

Part File NameMaterial
Part ACS
Part B304SS
Part CE-Glass
Part DCS
Part ECS

 

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.

Outcomes