Excel to ComboBox

[Ram]

Hi,

I have an interface that has combo box with all the 50 US STATES. I have the same 50states in an excel file.

Now I would like select the states in combo box accroding to the excel file column but I can't do it.

This is what I tried. I put a for loop and called this:

ControlFocus ("E", "", "ComboBox1")

ControlSetText ("E", "", $Columna[$i])

Msgbox (0, "State", $Columna[$i])

the above didn't do anything.

and I tried

ControlFocus ("E", "", "ComboBox1")

ControlSend ("E", "", $Columna[$i])

Msgbox (0, "State", $Columna[$i])

This just sends all states that are in the excel file.

Can you help me out in choosing the states in the combobox according to file?

Awaiting your response!

Thanks !

[Zedna]

If ComboBox is in your GUI then use GUICtrlSetData()

else use ControlCommand() and "AddString"

Also look at Au3Lib from PaulIA.