_ExcelReadSheetToArray - Error Code 4 When Excel Object Was Attached

[squishy]

The function _ExcelReadSheetToArray seems to always throw error 4 whenever called on an Excel object that was attached and not opened. I have traced the error back to line 533 in the function Excel.au3, where an ambiguous reference seems to be the issue. If you add the 'ActiveSheet' scope to the range when declaring the array, it seems to fix the issue:

Current line 533:
Local $aArray = $oExcel.ActiveSheet.Range($oExcel.Cells($iStartRow, $iStartColumn), $oExcel.Cells($iLastRow, $iLastColumn)).Value

Fixed line 533:
Local $aArray = $oExcel.ActiveSheet.Range($oExcel.ActiveSheet.Cells($iStartRow, $iStartColumn), $oExcel.ActiveSheet.Cells($iLastRow, $iLastColumn)).Value

I have included both a code file and a test Excel file for you to test out.

[squishy]

Dummy Excel File

[BrewManNH]

Version 3.3.8.1 is no longer the current version, have you tried this on the new release version? Does it still demonstrate the problem? The newest version is 3.3.10.0.

[guinness]

Yes it does. Changed the version.

[guinness]

Your proposed fix does not actually fix the error.

[water]

Won't be fixed because the next Beta of Autoit will include a completely rewritten Excel UDF.