Changing the ipart member in an assembly

[Anonymous]

I have an assembly (Skeletal modeling) and its spreadsheet specifies the thread size (bolt connection), which should specify which ipart member (bolt) should be activated. Can I change the ipart member using the “pure” excel or I need to use VBA.
Could you please guide me in what and how to do?

Thanks a lot
Luciano

[Anonymous]

>Can I change the ipart member using the “pure” excel

iAssemblies would be the closest thing to do this. Cannot do it w/ a linked Excel spreadsheet.

>I need to use VBA

You can use

ComponentOccurrence.ChangeRowOfiPartMember

[Anonymous]

Thanks Josh,

In my case the excel spreadsheet determines the bolt part number I shall use, then I think I should do a VBA macro inside the excel, which reads the part number (in a cell) and then change the ipart member (row) in Inventor.
I don't know much about VBA but I'm sure I can do it if you guide me.
Could you please explain me how do I do this?

Thank you very much