AnsweredAssumed Answered

change configuration using excel

Question asked by 1-PZUK60 on Oct 27, 2010
Latest reply on Jan 13, 2015 by Marco Gigante

Hi!

I am automating aa assembly through an excel sheet.
The system is more or less like this:

the values are inserted into cells that are linked to dimensions from a sketch.
At the end there is a command button that rebuilds the whole assembly according to the dimensions entered.
This whole system is done using vba code.

 

my question is whether if it is possible to create a line of code to change the part configuration according to the value entered in the cell.

 

Ex:

part1  has 3 configurations

part 2 has 2 configurations

 

cell B3 - config3 (part1)

cell F4 - config 2 (part2)

 

Assembly - part3 (config1) + part2 (config2)

 

I hope you understand my explanation and my question

Outcomes