Changing start cell with ilogic

[Anonymous]

Hello is it possible to use ilogic to change the "start cell" of a Excel parameters link?  If so can you help me out?

[JamieVJohnson2]

Excel based parameters are in an object called ParameterTables.  If you access the parent object of the known parameter it gives you the ParameterTable object, or you can get to it from Parameters.ParameterTables(indexvalue)

once you have the ParameterTable, use .StartCell and set to what you want.

[Anonymous]

Thank you. I am still learning; can you tell me if I am getting close?

Dim oPartDoc As Inventor.PartDocument
oPartDoc = ThisApplication.ActiveDocument
Dim oParams As Parameters
oParams = oPartDoc.ComponentDefinition.Parameters
oParameterTable = oParams.ParameterTables
oParameterTables=oParameterTables.ParameterTables
oStartCell=oParameterTables.StartCell()As String = ("A1")

[JamieVJohnson2 · Accepted solution]

Dim oPartDoc As Inventor.PartDocument
oPartDoc = ThisApplication.ActiveDocument
Dim oParams As Parameters
oParams = oPartDoc.ComponentDefinition.Parameters
oParameterTable = oParams.ParameterTables(1)
'oParameterTables=oParameterTables.ParameterTables
oParameterTable.StartCell = ("A1")

change as so.

[Anonymous]

Thank you Sir!