Hide Table of Contents

Get Model Pathnames from a BOM Table Example (VBA)

This example shows how to get the model pathnames from a specified row of a BOM table annotation.

' Preconditions:
' 1. Open a drawing containing a BOM table annotation named Bill of Materials1.
' 2. Open an Immediate Window.
' Postconditions: Inspect the Immediate Window for model pathnames.
' ---------------------------------------------------------------------------

Option Explicit

 Sub Main()

    Dim swApp       As SldWorks.SldWorks
    Dim swModel     As SldWorks.ModelDoc2
    Dim swDraw      As SldWorks.DrawingDoc
    Dim swFeat      As SldWorks.Feature
    Dim swBomFeat   As SldWorks.BomFeature

    Set swApp = Application.SldWorks
    Set swModel = swApp.ActiveDoc
    Set swDraw = swModel
    Set swFeat = swModel.FirstFeature
    Do While Not swFeat Is Nothing
        If (swFeat.GetTypeName = "BomFeat") Then
            Debug.Print "******************************"
            Debug.Print "Feature Name = " & swFeat.Name
            Set swBomFeat = swFeat.GetSpecificFeature2
            If (swFeat.Name = "Bill of Materials1") Then
                ProcessBomFeature swApp, swModel, swBomFeat
            End If
        End If
        Set swFeat = swFeat.GetNextFeature
End Sub
Sub ProcessBomFeature(swApp As SldWorks.SldWorks, swModel As SldWorks.ModelDoc2, swBomFeat As SldWorks.BomFeature)
    GetPathNames swApp, swBomFeat
End Sub

Sub GetPathNames(swApp As SldWorks.SldWorks, ByVal swBomFeature As SldWorks.BomFeature)
    Dim vConfigurations               As Variant
    Dim strConfiguration              As String
    Dim vVisibility                   As Variant
    Dim lIdx                          As Long
    Dim lNumConfigurations            As Long
    Dim lNumRow                       As Long
    Dim lNumColumn                    As Long
    Dim lRow                          As Long
    Dim swBOMTableAnnotation          As SldWorks.BomTableAnnotation
    Dim swTableAnnotation             As SldWorks.TableAnnotation
    Dim swDocument                    As SldWorks.ModelDoc2
    Dim swAssembly                    As SldWorks.AssemblyDoc
    Dim strDocumentName               As String
    Dim lStartRow                     As Long
    Dim bGetVisible                   As Boolean
    Dim vModelPathNames               As Variant
    Dim strItemNumber                 As String
    Dim strPartNumber                 As String
    Dim vModelPathName                As Variant
    Dim strModelPathName              As String

    strDocumentName = swBomFeature.GetReferencedModelName
    Set swDocument = swApp.GetOpenDocumentByName(strDocumentName)
    Debug.Print "Referenced model = " & strDocumentName
    Set swAssembly = swDocument

    ' For now assume we have only 1 table annotation.
    Set swBOMTableAnnotation = swBomFeature.GetTableAnnotations(0)
    Set swTableAnnotation = swBOMTableAnnotation
    lNumRow = swTableAnnotation.RowCount
    lNumColumn = swTableAnnotation.ColumnCount

   lStartRow = 1

    If (Not (swTableAnnotation.TitleVisible = False)) Then
        lStartRow = 2
    End If

    bGetVisible = False
    Debug.Print "# configurations = " & swBomFeature.GetConfigurationCount(bGetVisible)
    vConfigurations = swBomFeature.GetConfigurations(bGetVisible, vVisibility)

    If (Not IsEmpty(vConfigurations)) Then
        lNumConfigurations = UBound(vConfigurations) - LBound(vConfigurations) + 1
        For lIdx = 0 To (lNumConfigurations - 1)
            strConfiguration = vConfigurations(lIdx)
            Debug.Print ""
            Debug.Print "Configuration: " & strConfiguration

            For lRow = lStartRow To (lNumRow - 1)
                Debug.Print "  row = " & (lRow - lStartRow + 1)
                vModelPathNames = swTableAnnotation.GetModelPathNames(lRow, strItemNumber, strPartNumber)

                Debug.Print "    item number = " & strItemNumber
                Debug.Print "    part number = " & strPartNumber

                If (Not IsEmpty(vModelPathNames)) Then
                    Debug.Print "    # models contributing to row = " & swTableAnnotation.GetModelPathNamesCount(lRow)
                    For Each vModelPathName In vModelPathNames
                        strModelPathName = vModelPathName
                        Debug.Print "       " & strModelPathName
                    Next vModelPathName
                    Debug.Print "    # models contributing to row = 0"
                    Debug.Assert (False)
                End If
            Next lRow
        Next lIdx
    End If
End Sub

Provide feedback on this topic

SOLIDWORKS welcomes your feedback concerning the presentation, accuracy, and thoroughness of the documentation. Use the form below to send your comments and suggestions about this topic directly to our documentation team. The documentation team cannot answer technical support questions. Click here for information about technical support.

* Required

Subject:   Feedback on Help Topics
Page:   Get Model Pathnames from a BOM Table Example (VBA)
*   I acknowledge I have read and I hereby accept the privacy policy under which my Personal Data will be used by Dassault Systèmes

Print Topic

Select the scope of content to print:


We have detected you are using a browser version older than Internet Explorer 7. For optimized display, we suggest upgrading your browser to Internet Explorer 7 or newer.

 Never show this message again

Web Help Content Version: API Help (English only) 2014 SP05

To disable Web help from within SOLIDWORKS and use local help instead, click Help > Use SOLIDWORKS Web Help.

To report problems encountered with the Web help interface and search, contact your local support representative. To provide feedback on individual help topics, use the “Feedback on this topic” link on the individual topic page.