Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.
Anonymous
1855 Views, 11 Replies

Create 3d spline from excel worksheet using VBA

I need to automate the following action using VBA:

     In the user interface, with a Part file open, I select "Start 3D Sketch"

     In the Insert Panel, I select "Points" (which causes a File Open dialog box to open)

     Because I want a 3D Spline curve, I click on Options and select "Create Spline"

     I select an Excel workbook file that contains rows with X, Y, Z coordinate information, one row for each point

     The information in the Excel workbook is imported, the points are created, and a spline curve created through them

 

Can this action be accomplished using VBA, and if so, how.

 

Thanks.

 

 

command from the "Insert" panel