Add Thickness/Custom property column in Assembly drawing BOM using VBA

Hello

I am trying to put a "Thickness" and "Bounding Box Length and Width" column into my assembly Bom which as lot of sheet metal parts. I thought the below lines of code will help:

customPropArray = swBOMTableAnnotation.GetAllCustomProperties

    For Each customProp In customPropArray

        ' Debug.Print "  " & customProp

        If customProp = "Thickness" Then

        result11 = SWannotationtable.InsertColumn2(swTableItemInsertPosition_Last, 0, customProp, swInsertColumn_DefaultWidth)

        End If

    Next customProp

But I don't think this is right way of doing it. Can a macro traverse through the parts of assembly drawing and add a thickness in certain column, if a part is sheet metal? I read in forums about some free license of "document properties" thing which works without opening the part file. I don't want to do it that way. I have a final assembly and its drawing open and then run a macro which will do rest of work.

Please Help!

SolidworksApi/macros