Failure to load excel page

[ICANSEEYOU7687]

Im really frustrated and confused. I have two almost identical excel spreadsheets I am trying to load into autoit I am using...

Global $oXLC_Excel = _ExcelBookOpen("C:path375.xls")
Local $aArray = _ExcelReadSheetToArray($oXLC_Excel)

My first excel file it loads fine, but the next one it cant load it into an array and i have NO idea why. The have different data in them, but are structurally identical.

And if someone could refresh me on how to use the @error...its been a while and google returned nothing helpful.

I just dont understand why its not even loading. It definitely finds the file fine, and it even opens the excel document correctly.

Any help would be greatly appreciated.

Thanks

*EDIT*

if I can just do

If @error Then MsgBox(0, "Failure", @error)

Then this is returning a "1", which is saying object does not exist. When it does clearly find and open the excel sheet.

Edited September 4, 2012 by ICANSEEYOU7687

[BrewManNH]

Here's how to check if there's an error.

Global $oXLC_Excel = _ExcelBookOpen("C:path375.xls")
If @error Then
     MsgBox(64, "Error", "Error opening file: " & @error)
EndIf
Local $aArray = _ExcelReadSheetToArray($oXLC_Excel)
If @error Then
     MsgBox(64, "Error", "Error reading sheet to array: " & @error)
EndIf

[ICANSEEYOU7687]

Thanks! I have been fiddling and its not a file thing like I thought.

Its a termination thing. My loop is not terminating correctly like it was in the first excel file. I do not know why but I should be able to work with this a little better