_ExcelRangeFind error in line 656

[SorryButImaNewbie]

Good day everyone!

I'm having a problem with my underconstruction excel script (again... , sorry haven't used autoIT for a while, pretty sure this is a basic error as well)

If $xls2 = 1 Then
        $ExcelName = $aWorkBooks[2][1]
        $ExcelPath = $aWorkBooks[2][2]
        MsgBox($MB_SYSTEMMODAL, "Excel", " Excel file path: " & $ExcelPath)
        MsgBox($MB_SYSTEMMODAL, "Excel", " Excel file name: " & $ExcelName)
    EndIf

    If $xls3 = 1 Then
        $ExcelName = $aWorkBooks[3][1]
        $ExcelPath = $aWorkBooks[3][2]
        ;MsgBox($MB_SYSTEMMODAL, "Excel", " Excel file path: " & $ExcelPath)
    EndIf


$ExcelObject = _Excel_BookAttach($ExcelName, "filename")
If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_BookAttach Example 2", "Error attaching to '" & $ExcelObject & "'." & @CRLF & "@error = " & @error & ", @extended = " & @extended)
MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_BookAttach Example 2", "Search by 'filename':" & @CRLF & @CRLF & "Successfully attached to Workbook '" & $ExcelObject & "'." & @CRLF & @CRLF & "Value of cell A2: " & $ExcelObject.Activesheet.Range("A2").Value)


$knkod = _Excel_RangeFind($ExcelObject, "knkod")
If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeFind Example 1", "Error searching the range." & @CRLF & "@error = " & @error & ", @extended = " & @extended)
MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeFind Example 1", "Find all occurrences of value 'knkod' (partial match)." & @CRLF & "Data successfully searched.")
_ArrayDisplay($knkod, "Excel UDF: _Excel_RangeFind Example 1", "", 0, "|", "Sheet|Name|Cell|Value|Formula|Comment")

I ask my users, to only run one excel instances while starting my script (so I can develope a simple a script I can, and then upgrade it once I code like i was able to, once again...), thats why I dont use UBound but give an array of 4 for possible running excel detection. If its needed I can easly add to array size for now.

I check for given file extensions and also have an error+exit if I found more then 1 running excel. Of course I know that my code is pretty childish for now.

I use Excel_BookAttach to attach to the excel object, the script succesfully run, and gives back the value of A2 cell (code basicly copy pasted from help file) but then I get an error in the console that reads:

--> Press Ctrl+Alt+Break to Restart or Ctrl+Break to Stop
"C:\ToolBox\AutoIT\AutoIt3\Include\Excel.au3" (656) : ==> The requested action with this object has failed.:
$aResult[$iIndex][1] = $oMatch.Name.Name
$aResult[$iIndex][1] = $oMatch^ ERROR
->17:53:47 AutoIt3.exe ended.rc:1
+>17:53:47 AutoIt3Wrapper Finished.
>Exit code: 1    Time: 24.24

(sorry if i should have wrote this some other way)

I suspect that I screw something up with the workbook/worksheet handling or that $ExcelObject isn't an object somehow. I'm not sure, but IsObj return 1 if i check $excelobject

Edit: Maybe there is some kind of problem with the name of the excel? It has "á" in it's name, could that be a problem?

Thank you for your insight! and sorry for the elementary questions

Edited August 13, 2016 by SorryButImaNewbie
forgot something from the original post

[water]

It's a bug in AutoIt 3.3.14.2 with COM error handling.
If you search the forum for this bug you will find a few hits.