I created an Excel-file in which the user can chose a couple of different parts. After the parts have been chosen, i would like an implementation of these parts into Solidworks. So when, for example the sealmachine has been chosen for position 1, the sealmachine-part gets into the assembly at the first position. I also want to have a combination with custom lenghts into the designtable.
So for example, the sealmachine has been chosen for the first position with a length of 1500mm. Then the sealmachine-part has to been put in the first position with a total length of 1500mm.
I don’t advise to use VBA except feature or very small macro’s or testing API method. You make it even worse by using excel macro. Please learn C# or VB.Net. You will get much more possibilities and pleasure in programming.
2016 SOLIDWORKS API Help - AddComponent5 Method (IAssemblyDoc)