- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
Okay, I got it to work (Sort of). I was able to correct my coding error to allow for the cell value to load into my parameter, but it is not updating as I change the value of my BStyle Parameter. Apparently the BS_Name parameter is not linking to my rule dynamically. Any ideas?
GoExcel.Open("3rd Party:Embedding 2", "Sheet1")
MultiValue.List("BSeries") = GoExcel.CellValues("3rd Party:Embedding 2", "Sheet1", "B4", "")
Series = Parameter("BSeries")
rangeArray = GoExcel.NamedRangeValue("BS_" & BSeries)
Dim oList As ArrayList
oList = New ArrayList
Dim oRows
oRows = rangeArray.GetLength(0)
Dim oRowIndex As Integer
For oRowIndex = 3 To oRows
oList.Add(rangeArray(oRowIndex,1))
Next
MultiValue.List("BStyle")=oList
Dim nRow As Integer
For nRow = 4 To 100
If GoExcel.CellValue("o" & nRow) = Parameter("BStyle")
Parameter("BS_Name") = GoExcel.CellValue("P" & nRow)
End If
Next
GoExcel.Save
GoExcel.close
iLogicVb.UpdateWhenDone = True