[Solved] _Excel_RangeFind Error

[SkysLastChance]

I get this error, Whenever I try to find a date. Does anyone have any idea why? I saw some post from 2015, However I would imagine this is fixed by now. @water

>"J:\Temporary Files\XXXXXXXXX\AutoIt\AutoIt\AutoIt\SciTe\..\autoit3.exe" /ErrorStdOut "C:\Users\XXXXXX\Desktop\Call Report Automation.au3"    
"J:\Temporary Files\XXXXXXXX\AutoIt\AutoIt\AutoIt\Include\Excel.au3" (656) : ==> The requested action with this object has failed.:
$aResult[$iIndex][1] = $oMatch.Name.Name
$aResult[$iIndex][1] = $oMatch^ ERROR
>Exit code: 1    Time: 5.791

#include <Excel.au3>

Global $sExcelFile1 = FileOpenDialog("Choose/Create Excel File", @ScriptDir, "(*.xlsm)")
Global $sExcelFile2 = FileOpenDialog("Choose/Create Excel File", @ScriptDir, "Excel Sheet (*.xlsx;*.xls)|All (*.*)")

If FileExists($sExcelFile2) Then
   Global $oExcel2 = _Excel_Open ()
    $oExcel2 = _Excel_BookOpen($oExcel2,$sExcelFile2)
EndIF

If FileExists($sExcelFile1) Then
   Global $oExcel1 = _Excel_Open ()
    $oExcel1 = _Excel_BookOpen($oExcel1,$sExcelFile1,Default,Default,"2007")
EndIF


$oRead = _Excel_RangeRead ($oExcel2,Default,"A2",3)
_Excel_RangeWrite ($oExcel1,"Calls Handled",$oRead,"BY7")

Sleep (1000)

_Excel_RangeFind ($oExcel1,$oRead,"E4:FD92")

MsgBox  (0,"Test",$oRead)

UPDATE:

If I take out this line it works. By works I mean I don't get the error. :/  However, I need it. I am just confused.

_Excel_RangeWrite ($oExcel1,"Calls Handled",$oRead,"BY7")

 

UPDATE 2: I also get this error when trying to use the helpfile examples. I have version 3.3.14.2

\AutoIt\AutoIt\AutoIt\Include\Excel.au3" (670) : ==> The requested action with this object has failed.:
$oSheet = $oWorkbook.Sheets($iIndexSheets)
$oSheet = $oWorkbook^ ERROR
>Exit code: 1    Time: 0.8931

 

Edited July 13, 2017 by SkysLastChance

[water]

Did you update the Excel UDF as described here?