VB script for a blend with variable number of coupling points

[jarmusch]

Hi ENG-Tips,

(long time reader, first time poster)

I'm getting to grips with scripting in CATv5r19 VBA, and have come up against a problem in excess of my (somewhat meagre) ability:

I wish to automate the creation of a blend surface between two guides, using coupling points that are referred to in a spreadsheet.

The problem is, the number of coupling points may change, so i need a way to accommodate this in the script which creates the blend.

My spreadsheet creates the coupling points, and there is a cell which is a 'readout' of the total number of these; what I need is a way to insert them into the blend script at creation, regardless of how many or few there are.

I'm assuming I need a Sub that parses the coupling points, creates the catia code for them and inserts that into the blend operation.

But how to do that has me stumped.

Any ideas?

thanks in advance

Jarmusch