Drawing smooth curves

[nic]

Hi
Trying to draw hundreds of smooth curves from an Excel spreadsheet and struggling to find a way that doesnt require manual intervention.

I currently have a macro that reads in the node points (Excel only has the x,y coordinates) and draws overlapping curves - the first two/last three nodes overlap the previous/next curve. Each part of each curve is created with AppendLineSegment then the curve is created with CreateCurve. I can then manually select each curve/select All Nodes/To Curves/Smooth and use a macro to delete the first and last node, ending up with non-overlapping curves that look like a continuous smooth line.

I had tried to use AppendCurveSegment but whilst this created curved nodes with handles the lines were not smooth - I think because of the lack of control handle information and I would need to manually change the nodes back To Lines before converting them back To Curves.

The method wasnt good but I could get away with it with a few curves but now I want to draw hundreds of small curves of about 20 nodes each and Im wondering if someone could give advice about how to go about it.


Best wishes
nic