Modify

Opened 14 years ago

Closed 14 years ago

Last modified 14 years ago

#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 Aru, 14 years ago

Windows 7, Excel 2010

comment:2 by anonymous, 14 years ago

missing a repro script
Thanks

comment:3 by trancexx, 14 years ago

Resolution: Fixed
Status: newclosed

Even though the issue is not directly addressed, it's fixed in next beta as collateral.

comment:4 by J-Paul Mesnage, 14 years ago

not sure it was not a NO BUG as we cannot reproduce without a repro script.

Modify Ticket

Action
as closed The ticket will remain with no owner.

Add Comment


E-mail address and name can be saved in the Preferences .
 
Note: See TracTickets for help on using tickets.