ds-blue-logo
Preview  |  SOLIDWORKS USER FORUM
Use your SOLIDWORKS ID or 3DEXPERIENCE ID to log in.
CCCraig Clanachan05/06/2014

I am importing sketch points from excel using the macro  however points that are close to each other are snapping to horizontal or vertically alignment depending on the level of zoom when the marco is run.  I think I need to use the I.Sketch.Manager::SetAddtoDB function but I am not sure on the syntax to achieve this.

Thanks in advance for your help

Option Explicit
Sub main()
Dim swApp As SldWorks.SldWorks
Dim Part As SldWorks.ModelDoc2
Dim Excel As Object
Dim i As Integer
Dim xpt As Double
Dim ypt As Double
Dim zpt As Double


Set swApp = Application.SldWorks
Set Part = swApp.ActiveDoc
Set Excel = GetObject(, "Excel.Application")


Part.SketchManager.InsertSketch True
i = 1
Do While Excel.Cells(i, 1) <> ""
    xpt = Excel.Cells(i, 1) / 1000
    ypt = Excel.Cells(i, 2) / 1000
    zpt = Excel.Cells(i, 3) / 1000
    Part.CreatePoint2 xpt, ypt, zpt
    i = i + 1
Loop