Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.
asmenut
in reply to: asmenut

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