AnsweredAssumed Answered

Driving dimension tolerance of part from excel

Question asked by Sf Ssfg on Nov 12, 2017
Latest reply on Nov 19, 2017 by Nilesh Patel

Hello all,

I would like to ask you about driving dimmension tolerance of part from excel.

I have simple part (block) with 3 dimmension and excel table with 3 rows and macro.  This macro easily insert value from excel cell to solidworks dimmension.


Private Sub CommandButton1_Click()

Dim swApp As SldWorks.SldWorks

Set swApp = CreateObject("SldWorks.Application")

swApp.Visible = True

Set Part = swApp.ActiveDoc

Part.Parameter("a@Sketch1@box.part").SystemValue = Excel.Range("B2") / 1000

Part.Parameter("b@Sketch1@box.part").SystemValue = Excel.Range("B3") / 1000

Part.Parameter("D1@Boss-Extrude1@box.part").SystemValue = Excel.Range("B4") / 1000



End Sub


This part is working fine, but I would like to driving dimmension tolerance (symmetric, bilateral) from excel somehow.

Is there any way how to do it?


Simply example in attachment (excel, solidworks part).


Thank you




Final solution in attachment