



They should result in a spline controlled by the values of Excel Zoom All command to display the imported coordinates. The 3D spline option imports 3D coordinates as 3D spline (a new sketch object introduced in Inventor R8).įor the Sample table use Rows range 2-132 The 3D points option imports 3D coordinates as WorkPoints (instead of 2D splines). In the Point import dialog enter the values depending on the format of your data in the Microsoft Excel sheet (enter the number of column containing X-data, column with Y-data, etc.).

In the Macro Name list select the Module1.ImportCoords item.In the Macros dialog, in the Macros in list select the All application projects.If no sketch is active this function will not work. Warning This function requires an active sketch. In Autodesk Inventor start a new part file and a new sketch (or leave theĪctive sketch).Note Coordinates must be stored so that X coordinates are in one column and In Microsoft Excel open the sheet with point coordinates.Close the Microsoft Visual Basic window.Select the project file ImportCoordinates.ivb.In the Microsoft Visual Basic window select File Load Project.In the Tools menu select Macro Visual Basic Editor.Allow to sketch graphs of mathematical functions. Simplifies creation of irregular 3D objects driven by computed or digitized point coordinates. ImportCoord is a VBA add-on application for Autodesk Inventor allowing to read in sketch splines from coordinates stored in Excel sheets. ImportCoord for Inventor Read in Inventor sketch splines and points from Excel tables
