API VBA: Getting BOM Part NO.

How do you access the part number that will show up in the BOM for a
specific component. For example: I am in a drawing, and want to open a
specific part. Get its part number and search an excel spreadsheet to get
our database description for that part. Does anyone have a quick example or
something. Thanks.

Corey Scheihc

 

using solidworks api

1.drawingdoc::getfirstview "get the first drawing view"
2.View::Getbomtable "check for a bom table and get it"
3.view::getnextview "get next view and so on"
4.View::Getbomtable "check for a bom table and get it"
5.bomtable::attach3 "you must gain access to the bom in order to read it"
6.gettotalcolumncount "get number of columns"
7.gettotalrowcount "get number of rows"
8.getentrytext "using the Getbomtable object" & "columncount" & "rowcount"
9.bomtable::detach "release the bom"


for exp.

for i = 1 to gettotalcolumncount

for k = 1 to gettotalrowcount

mystring = Getbomtable.getentrytext(k,i)

debug.print mystring

next k

next i

 

Don't worry I got it.

Sub GetConfigNameInBOM()

Dim swApp As SldWorks.SldWorks
Dim swDoc As SldWorks.ModelDoc2
Dim Config As SldWorks.configuration
Dim BOM_Name As String
Dim ANameOn As Boolean

Set swApp = Application.SldWorks
Set swDoc = swApp.ActiveDoc
Set Config = swDoc.GetActiveConfiguration

ANameOn = Config.UseAlternateNameInBOM

If ANameOn Then
BOM_Name = Config.alternateName
If BOM_Name = "" Then
BOM_Name = Config.Name
End If
Else
BOM_Name = swDoc.GetTitle
End If

End Sub