link excel file to inventor with vb.net

[Burnit87]

hey, i'm doin my graduation thesis about programming inventor, and i'm stuck

i need to automaticly import an excel sheet to my parameters with vb.net

please help me

thanks in advance

Björn

[Burnit87 · Accepted solution]

i've found a solution on

http://adndevblog.typepad.com/manufacturing/2012/08/accessing-inventor-parameters.html

i simplified it to

PrivateSub CreateLink()

'set excel file location as string

Dim strExcelLocation AsString = fbDlg.SelectedPath & "\" & txtPartName.Text & ".xlsx"

'acces active documents parameters

Dim allparams AsParameters = _invApp.ActiveDocument.componentdefinition.parameters

'link excel file with part parameters

allparams.ParameterTables.AddExcelTable(strExcelLocation, "A1", True)

'save part

_invApp.ActiveDocument.Save()

EndSub