Hi,
I´m trying to code a little script for searching values in an excel sheet.
I have a excel sheet and in the Range D2:D40 is the string "821940" I want to search.
#include <ExcelCOM_UDF.au3>
#include <Array.au3>
$Excel = _ExcelBookOpen(@ScriptDir & "\L27.xls", 1,False)
$array = _ExcelFindInRange($Excel, "821940", "D2:D40",1,1,1,0,2,False,False)
_ArrayDisplay($array,"RESULT")
_ExcelBookClose($Excel)
It opens the excel sheet but I get always an error
F:\TEMP PLATTE\AutoIt\excel\ExcelCOM_UDF.au3 (1096) : ==> The requested action with this object has failed.:
$oFound = $oExcel.Selection.Find($sFindWhat, $oExcel.ActiveCell, Default, $iWholeOrPart, Default, Default, $fMatchCase, Default, $fMatchFormat)
$oFound = $oExcel.Selection.Find($sFindWhat, $oExcel.ActiveCell, Default, $iWholeOrPart, Default, Default, $fMatchCase, Default, $fMatchFormat)^ ERROR
I don´t know where the problem is - can anyone help me ?