iLogic - MultiValue Parameter - Get Named Range From Embedded Excel

[matt_jlt]

Hi,

I have a MultiValue Parameter that I want to populate using a named range from an embedded excel spreadsheet. I would like an iLogic solution if possible because I need other people to be able to understand the code without too much difficulty.

One of the sample snippets given allows access but not if the excel file is embedded.

'GoExcel.NamedRangeValue("Part_Width")

 The code below works but not when using a named range.

' Load bearing housing types
MultiValue.List("parameter1")  = GoExcel.CellValues("A1","A20")

 Is there something I'm missing? I was hoping to use something like below

' Populate MultiValue Parameter from excel
MultiValue.List("parameter1") = GoExcel.CellValues("3rd Party:Embedding 4", "Sheet", "myNamedRange")

Thanks, Matt.

[MegaJerk]

I have an excel file that is embedded inside of a part and the code I use is as follows.

MultiValue.List("MULTIVALUE")=GoExcel.CellValues("3rd Party:ExcelFileName", "Workbook", "column", "")

[codyc-9096]

Was there ever a solution to this? I am having the same problem. The last snippet you suggested is exactly what I thought would work, but it doesn't...