Sorry, I am having problems attaching the file. Here is the code though, you can see the API calls there, and set up your sheet in Excel. I'll try to still post the workbook later.
Option Explicit
Dim swApp As Object
Dim Part As Object
Dim boolstatus As Boolean
Dim longstatus As Long, longwarnings As Long
Dim FeatureData As Object
Dim Feature As Object
Dim Component As Object
Dim RowNum As Integer
Dim XCoord As Double
Dim YCoord As Double
Dim ZCoord As Double
Private Sub cmdExportPoints_Click()
Set swApp = CreateObject("SldWorks.Application")
Set Part = swApp.ActiveDoc
'Part.Insert3DSketch
RowNum = ActiveCell.Row
XCoord = (Range("B" & RowNum) - Range("J2")) * 0.0254
YCoord = Range("C" & RowNum) * 0.0254
ZCoord = Range("D" & RowNum) * 0.0254
Part.CreatePoint2 XCoord, YCoord, ZCoord
If chkFixPt = True Then
Part.SketchAddConstraints "sgFIXED"
End If
Part.ClearSelection2 True
'Part.InsertSketch2 True
End Sub
Private Sub cmdMirrorPoint_Click()
Set swApp = CreateObject("SldWorks.Application")
Set Part = swApp.ActiveDoc
'Part.Insert3DSketch
RowNum = ActiveCell.Row
XCoord = ((Range("B" & RowNum) - Range("J2")) * (-1)) * 0.0254
YCoord = Range("C" & RowNum) * 0.0254
ZCoord = Range("D" & RowNum) * 0.0254
Part.CreatePoint2 XCoord, YCoord, ZCoord
If chkFixPt = True Then
Part.SketchAddConstraints "sgFIXED"
End If
Part.ClearSelection2 True
'Part.InsertSketch2 True
End Sub
Private Sub Create3dSketch_Click()
Set swApp = CreateObject("SldWorks.Application")
Set Part = swApp.ActiveDoc
Part.Insert3DSketch
End Sub
Private Sub optFixPt_Click()
End Sub