_IEFormElementSetValue using array

[cheesestain]

I'm trying to input text from an an excel file stored in an array using _IEFormElementSetValue

_IEFormElementSetValue($oQuery, $aResult[$i][0])

But i'm getting this error when i execute: Array variable has incorrect number of subscripts or subscript dimension range exceeded

I verified that i can use $aResult[$i][0]) in a msg box and it displays the result i want but for some reason I can't use it in _IEFormElementSetValue

[Danp2]

Not enough information. Is this being performed within a loop? What is the value of $i when the error occurs? How big is the array?

[cheesestain]

It's in a For loop.  The value of $i is 1 and the array is small.  3 columns and 5 rows.

For $i = 1 to UBound($aResult);
_IEAttach("3M")
_IELoadWait($oIE)

Local $oForm = _IEFormGetObjByName($oIE, "pricingSearchForm")
$oQuery = _IEFormElementGetObjByName($oForm, "productNum")

_IEFormElementSetValue($oQuery, $aResult[$i][0])

 

[Danp2]

For $i = 1 to UBound($aResult)

This probably should be

For $i = 0 to UBound($aResult) - 1

 

[cheesestain]

5 hours ago, Danp2 said:

For $i = 1 to UBound($aResult)

This probably should be

For $i = 0 to UBound($aResult) - 1

 

Thank you!  It worked!