Help with dropdown in webpage

[ice1000]

I want to retrieve each option value from a select tag on a web page and list them in one column in Excel. My code correctly retrieves the option value but it puts each value in the same cell instead of moving down one cell for each value.

Anyone have any ideas on what I am doing wrong?

$oExcelx = ObjGet("","Excel.Application");Get current instance of Excel
$oIE = _IEAttach("Sheet Editor")

$oExcelx.Activeworkbook.Activesheet.range("D1").Activate

;trying to get correct found account
$oFoundAccount = _IEGetObjById ($oIE, "SelectAccounts")
$o_Options = _IETagNameGetCollection($oFoundAccount, "option")

For $o_Option in $o_Options
    $iCurrentRow = 1
    $oExcelx.Activeworkbook.Activesheet.cells($iCurrentRow,4).value = $o_Option.text
    $iCurrentRow = $iCurrentRow + 1
Next

[martin]

$oExcelx = ObjGet("","Excel.Application");Get current instance of Excel
$oIE = _IEAttach("Sheet Editor")

$oExcelx.Activeworkbook.Activesheet.range("D1").Activate

;trying to get correct found account
$oFoundAccount = _IEGetObjById ($oIE, "SelectAccounts")
$o_Options = _IETagNameGetCollection($oFoundAccount, "option")

For $o_Option in $o_Options
    $iCurrentRow = 1;<----------------move this to before the for/next loop#############################
    $oExcelx.Activeworkbook.Activesheet.cells($iCurrentRow,4).value = $o_Option.text
    $iCurrentRow = $iCurrentRow + 1
Next

[ice1000]

THAT was a simple programming error.

I can't test because the code refuses to work.

When executing, I get the following error: Variable must be of type "Object".:

Excel is open and the ObjGet is apparently not getting the correct object.

Why is the code all of the sudden bombing?

[ice1000]

THAT was a simple programming error.

I can't test because the code refuses to work.

When executing, I get the following error: Variable must be of type "Object".:

Excel is open and the ObjGet is apparently not getting the correct object.

Why is the code all of the sudden bombing?

Rebooting solved the problem. This has happened a few times.

Is there a way to 'reset' AutoIt so I don't have to reboot?

[DaleHohm]

It is not AutoIt that needs to be "reset". More likely it is a foobar excel.exe running on your system. Exit Excel and then use task manager to kill excel.exe if it is still running.

Dale