AnsweredAssumed Answered

Hole Table Update Very Slow...

Question asked by Dave Paul on Apr 27, 2018
Latest reply on Apr 30, 2018 by Mike Spens

I have a macro that adds three rows of calculated data to a hole table.  I'm using an Excel worksheet function for some of the calculations.  When I add the data to the hole table with a loop, it is a long process.

I have other macros that add data to BOM tables that are very fast.  Where is my issue??  Thank you for your help.


UPDATE: Adding the command "swHoleTable.EnableUpdate = False" doesn't help.


Dim swHoleTable As SldWorks.HoleTable
    Dim swTableAnn As SldWorks.TableAnnotation
    Dim swHoleTableAnn As SldWorks.HoleTableAnnotation
    Dim swAnn As SldWorks.Annotation

    boolstatus = swModel.Extension.SelectByID2("Hole Table1", "HOLETABLE", 0, 0, 0, False, 0, Nothing, 0)
    Set swHoleTable = swSelMgr.GetSelectedObject6(1, -1)
    Set swHoleTableAnn = swHoleTable.GetTableAnnotations(0)
    Set swTableAnn = swHoleTableAnn
    If swTableAnn.ColumnCount < 7 Then
      Call swTableAnn.SetColumnTitle(4, "DD")
      Call swTableAnn.InsertColumn2(swTableItemInsertPosition_Last, 0, "DMS", swInsertColumn_DefaultWidth)
      Call swTableAnn.InsertColumn2(swTableItemInsertPosition_Last, 0, "BC", swInsertColumn_DefaultWidth)
    End If

     ' Calculations happen here...
     ' Slow text insertion loop
    For I = 0 To UBound(dblTableData)
      swTableAnn.Text(I + 1, 4) = CStr(dblTableData(I, 2))
      swTableAnn.Text(I + 1, 5) = CStr(dblTableData(I, 3))
      swTableAnn.Text(I + 1, 6) = CStr(dblTableData(I, 4))
    Next I