Controlling a parameter of a part with Excel data - Very difficult to perform this operation

Hello

I admit that this type of request has already been requested on this site, but I have already gone through the questions of the forum in all its forms and I still can't find a solution.

It turns out that for a project, one of the tasks is to vary the color of the parts of an assembly, according to excel data.

Let's imagine that I have a cube and that cube is cut into 4 other 'small' cubes. I can't find at all the macro that would associate each small cube with a piece of data from an excel table.

Could you help me perform this macro?

I'm also on CATIA, so if the technical solution is easier to set up with this software, don't hesitate to tell me

Thank you!

K.E

Hello

You should be able to get by with part families because you can then control the colors of the components or bodies (See SW help).

http://help.solidworks.com/2016/french/solidworks/sldworks/r_color_parameter_in_configurations.htm

Kind regards

3 Likes

Hello

I didn't know about it, I'll see if it can help me.

Thank you for taking the time to respond!

Have a nice day