It runs half way then stops

[sysadmin]

Ok.... after many hours of searching and trial an error (plus some help from people) I have gotten most of this thing figured out. It runs half way through the script and then stops when it is supposed to input data from excel. I just cant figure out where the link is broken.

expandcollapse popup

#include <File.au3>
#include <Array.au3>
#include <Excel.au3>

local $oExcel = _ExcelBookOpen("C:\Users\mcrown\Documents\searchresultstest.xls")
$aArray1 = _ExcelReadSheetToArray($oExcel,1,1,0,1,True)
_ExcelBookClose($oExcel)
_ArrayDisplay($aArray1)
$rows = UBound($aArray1)-1

WinActive("CORRIDOR", "")
WinSetState("CORRIDOR","",@SW_MAXIMIZE)


WinActivate("CORRIDOR", "")
send("!t")
send("{down 2}")
send("{right}")
send("{down 3}")
send("{ENTER}")

WinWaitActive("CORRIDOR", "", 5)
WinActivate("Current Parts in Inventory Search", "")

WinWaitActive("CORRIDOR", "", 5)
ControlCommand("Current Parts in Inventory Search", "", "SysTabControl323", "TabRight", "")
send("{TAB}")

for $c = 1 to $rows
ControlClick("Current Parts in Inventory Search", "Lot number", 1070, "left")
WinWaitActive("Current Parts in Inventory", "Lot Number", 5)
ControlSend("Current Parts in Inventory Search", "Lot Number", 1070, $aArray1[$c][0])
ControlClick("Current Parts in Inentory Search", "Scan", 1062, "left")
ControlClick("Current Parts in Inventory Search", "open", 1663, "left")

send("{TAB 7}")
send("Lowcountry Trading IV, LLC")
send("{TAB}")
send("Lowcountry Trading IV, LLC")

WinActivate("Edit Lot", "")
WinWaitActive("Edit Lot", "", 3)
ControlCommand("Edit Lot", "", "SysTabControl321", "TabRight", "")
ControlCommand("Edit Lot", "", "SysTabControl321", "TabRight", "")
ControlCommand("Edit Lot", "", "SysTabControl321", "TabRight", "")
ControlCommand("Edit Lot", "", "SysTabControl321", "TabRight", "")
next

Yes, I know I've probably added a lot of strings that are unnecessary, but I'm still learning.

[dufran3]

At first glance, I would guess it's stopping at one of the WinWaitActive() functions, Try writing in some

ConsoleWrite()

lines before and after those to be sure it isn't stopping there. If it is stopping there, make sure you specify your

WinTitleMatchMode

it can be found in the help file. I believe by default it only matches the window starting at the beginning, and only does partial match. Feel free to correct me if anything I said is...foolish

[BrewManNH]

There is an Excel UDF that would probably make this a lot easier than trying to manually jump around the screen to various locations on a spreadsheet.

[sysadmin]

Well, I'm not trying to jump around to various locations. I need to go down in sequence on one column. The navigation through my GUI works fine I just dont think it is building the array from the Excel spread sheet. If I could just get this part nailed down I can start writing all of the other scripts I need to. For some reason this part is confusing the crap outa me.

Edited April 5, 2011 by sysadmin