Run an application once, enter all data from excel and then logout the application

[Gokul]

Hi, 

Is it possible to once login to an application and the execute datas from an excel into the fields in the application. After one row of datas from the excel is entered into the fields the submit button should be clicked. Then the second row of data should be fetched from excel and entered into the field, like this for all rows of data. After all datas are submitted, the application should logout. I have used a code like,

#include <excel.au3>
#include <array.au3>
$file = "Excel_path"
$oExcel = _ExcelBookOpen($file, 0)      
_ExcelSheetActivate($oExcel, "Sheet1")       
$aArray = _ExcelReadSheetToArray($oExcel, 1)
_ArrayDisplay($aArray, "Array using Default Parameters")
For $i = 1 to UBound($aArray)
$ClickC1_1    =$aArray[$i][1]
Run('application_path')
_WinWaitActivate("Example Lookup Combobox","")
MouseClick("left",$ClickC1_1,71,1)
MouseClick("left",458,88,1)
Sleep(4000)
;Send("{TAB}")
MouseClick("left",480,71,1)
MouseClick("left",458,88,1)
Sleep(4000)
MouseClick("left",479,70,1)
MouseClick("left",460,99,1)
_ExcelBookClose($oExcel, 0, 0)
$oExcel = ''
Next

 

But, this opens the application parallelly.

Edited February 4, 2014 by Gokul

[Gokul]

I think i got a solution to this. When i placed the Run command outside the for loop (below _ArrayDisplay($aArray, "Array using Default Parameters")), its working as expected.

[water]

To make your script more reliable (independant of screen size and window positions) I would replace all MouseClick and Send statements with ControlClick or ControlSend.

[Gokul]

To make your script more reliable (independant of screen size and window positions) I would replace all MouseClick and Send statements with ControlClick or ControlSend.

These are comboboxes and when i give ControlCommand, its not working. I gave like,

ControlCommand("Title", "", "[NAME:controlname]", "ShowDropDown")

ControlCommand("Title", "", "[NAME:controlname]", "SelectString", 'Test')

But its not selecting the value 'Test' from the combobox.

Edited January 27, 2014 by Gokul