Hi All,

I am new to vba and trying to edit an existing macro which is attached. The macro is run from excel. One portion of this macro calls CATIA, a 3d CAD application, and creates a series of points. What i want to do is create spheres centered on those points.

As the subroutine loops, it reads lines columns of x, y, and z values of a point, and creates as many points as there are rows. Can I add a
AddNewSphere function before it advances to the next row or do I have to create a separate subroutine.
Your assistance is greatly appreciated.
thanks