How can I get the values from the Part Number column in a member table

[fsdolphin]

Hi,

How can I get the PartNumbers from a member table?

Here is how I'm getting the MemeberNames but I don't see how I can get the values form the PartNumber column.

  For Each row As iPartTableRow In factory.TableRows
     memberList.Add(row.MemberName)
  Next

Thanks

[MechMachineMan]

iPartTableColumns.Item Property

Description

Returns the specified iPartTableColumn object from the collection. This is the default property of the iPartTableColumns collection object.

Syntax

iPartTableColumns.Item( Index As Long ) As iPartTableColumn

[fsdolphin]

@MechMachineMan

Hi,

I honestly don't know how to use the Item Property you are suggesting. Could you please help me a little bit more showing me or telling me how to add this property to my For Each for loop?

Thanks

[MechMachineMan]

What is your end goal that you are trying to accomplish with this sub
routine?

[fsdolphin]

@MechMachineMan

What I'm trying to do is add all of the part numbers in the table to the Keywords field from the iProperties. I was able to add all of the names in the Member Name column but I need the part numbers not the memer names.

FYI - I'm doing this for better searchability in Vault.

[MechMachineMan]

Looks like you have to use columns to figure out which column contains part numbers, then use that in conjunction with row data and access the cell that corresponds to the column you just found.

[Balaji_Ram]

To add to Justin's reply :

You can iterate and get the column display heading to know which column holds the part number. That should help you retrieve it.

Dim oFactory As iAssemblyFactory
Set oFactory = oAsmDoc.ComponentDefinition.iAssemblyFactory

If oFactory.TableColumns.Count > 0 Then
Dim tableCol As iAssemblyTableColumn
For Each tableCol In oFactory.TableColumns
MsgBox tableCol.DisplayHeading
Next
End If

Regards,

Balaji