_Excel_RangeFind fails without throwing error when searching inactive book with string as Range

[TheAppleFreak <theapplefreak@…>]

Using _Excel_RangeFind on an inactive workbook with a string as the range fails the search, but does not return 0 or throw an error. Passing a Range object or having the sheet be active works as expected.

Looking in Excel.au3, the culprit appears to be in this If statement:

If $vRange = Default Then
	$bSearchWorkbook = True
	$oSheet = $oWorkbook.Sheets(1)
	$vRange = $oSheet.UsedRange
ElseIf IsString($vRange) Then
	$vRange = $oWorkbook.Parent.Range($vRange)
	If @error Then Return SetError(3, @error, 0)
EndIf

$oWorkbook.Parent.Range($vRange) should be changed to $oWorkbook.Sheets(1).Range($vRange) instead.

[TheAppleFreak <theapplefreak@…>]

Minimal file to show the nature of the bug, as tested with Excel 2007.

[water]

Fixed by revision [11252] in version: 3.3.13.21

[water]

Fixed by revision [11253] in version: 3.3.13.21