#2056 closed Bug (Fixed)
Excel.au3 - 5 Broken Functions
| Reported by: | Aru | Owned by: | |
|---|---|---|---|
| Milestone: | Component: | AutoIt | |
| Version: | 3.3.7.21 | Severity: | None |
| Keywords: | Excel Excel.au3 | Cc: |
Description
3.3.7.21(beta)
3.3.6.1
Any reference to $oExcel.ActiveWorkbook.Sheets.Count after creating the Excel object with _ExcelBookAttach() seems to error. These are the five functions with that reference:
_ExcelBookOpen
_ExcelSheetDelete
_ExcelSheetList
_ExcelSheetActivate
_ExcelSheetMove
And this is the error:
C:\Program Files\AutoIt3\Include\Excel.au3 (1063) : ==> The requested action with this object has failed.: Local $iTemp = $oExcel.ActiveWorkbook.Sheets.Count Local $iTemp = $oExcel.ActiveWorkbook^ ERROR
References to $oExcel.ActiveWorkbook.Sheets() work fine. It's the ones without parenthesis that break. They also all work fine if the object is created with _ExcelBookOpen() instead of _ExcelBookAttach().
Attachments (0)
Change History (4)
comment:1 by , 14 years ago
comment:3 by , 14 years ago
| Resolution: | → Fixed |
|---|---|
| Status: | new → closed |
Even though the issue is not directly addressed, it's fixed in next beta as collateral.
comment:4 by , 14 years ago
not sure it was not a NO BUG as we cannot reproduce without a repro script.

Windows 7, Excel 2010