How to create a 3d-spline with VBA automaticly

[Anonymous]

Hello!

I wonder if I could have a solution of my following problem:

I work with pressure springs which usually have different shapes/profiles than cylinder; it means, the diameter-values of both ends don't need to be the same, even the profile not linear - the profile can be a mathematical function like parabolic or what ever. It is not enough: The center -pressing- axis of this spring doesn't need to be a linear one because the spring sometimes has an arc-type (radial) movement if that's pressed.

I want to create a parametric spring with different parameters:

The start&end diameters

Wire diameter

Profile function

Axis-Curve (first only radial which can become linear with Curvature --> 0)

Number of Revolution

I solved the computing part of points simply via excel. But I need to get the 3D-Spline (depending on these parameters) which will be the path of the spring (the profile is the circle with the wire diameter). Please note that the number of revolution (coil) itself is also one of the parameters.

I need a program which:

1) reads the -already computed- 3D-points (control points of the interpolating 3D-Spline) from the excel file

2) reads other parameters (if necessary)

3) can "identify" the points and their order (like point-objects by allocating point-object-names for example as order-numbers: P_01, P_02, etc.)

4) starts the command "Create a 3D-Polyline (Spline)" beginning with the "first" point via other interpolating control points and finally the "end" point (natural end-conditions).

5) starts the command "Sweep" by identifying the round profile and the recently generated 3D-Spline inclusing start point (the start point can just be "at" the profile)

so on...

I mean I need a quasi-automaticly creation of a pressure spring with -almost- any shape!

Has anyone already tried to solve such a problem like this using VBA?

I would appreciate any answers. Many thanks in advance.

with my kindest regards

Gokhan