How to use array as input in IE

[_Ray]

Hi All,

I was searching for a topic here but I was not able to find one that can answer my problem. I posted yesterday about how to read excel and I was able to get it done (thanks to Subz) but my problem now is how I can use the values I got as an input in IE. It gives me an error when trying to use it directly. I am attaching sample image of the error. Sorry I can't copy the text since it was restricted as I am working remotely

[Danp2]

Local $datawb.worksheets("Sheet1").Activate

You need to remove the Local at the beginning of this line.

For $x = 1 UBound($aMyData) - 1

You're missing the "To" between 1 and UBound.

As far as setting the value of the Input element, take a look at the help file entry for _IEFormElementSetValue.

[_Ray]

ohhh!!! I feel so dumb. It's great to have another set of eyes. Thank you so much @Danp2 

[_Ray]

Another error encountered. Variable must be of type "Object". Can you help me what seems to be the problem? 

[Luke94]

Line 177 needs changing to:

Local $datawb = _Excel_BookOpen($oExcel, @ScriptDir & '\SBMO Store setting input.xlsx')

You we're passing '\SBMO Store setting input.xlsx' into the $bReadOnly parameter.

[_Ray]

7 hours ago, Luke94 said:

You we're passing '\SBMO Store setting input.xlsx' into the $bReadOnly parameter.

I didn't notice this part. I wasted a day for this. Thank you very much @Luke94.

This forum is really awesome. It really helps newbies like me