_ExcelBookOpen False Negative? 2010

[jdelaney]

When I run this line of code

#include <Excel.au3>

$oExcel = _ExcelBookOpen ( "C:UsersjdelaneyDesktoptestResults.xlsx" )

If Not $oExcel > 0 Then

MsgBox ( 4096, "Excel", "Unable to open file call=[" & $oExcel & "]" & "@error=[" & @error & "]." )

EndIf

The Excel application opens, and the specific file opens in it, but the function returns NULL with an @error = 0. Any ideas why this is the case? I'm using 2010 Excel on a Win7 machine. The message box displays: "Unable to open file call=[]@error=[0]."

Thanks.

[added #include <Excel.au3>]

Edited February 8, 2012 by jdelaney

[water]

What version of AutoIt do you use?

[jdelaney]

ouch, who would have thought an object can't be seen in a string...disregard...not sure how to close/delete

[jdelaney]

I should have done IsObj to validate the object

[jdelaney]

Found an actual issue:

$oExcel = _ExcelBookNew ( True )

If isObj ( $oExcel ) Then

MsgBox ( 4096, "Pass", "New Excel created" )

Exit

Else

MsgBox ( 4096, "False Pos", "Returned=[" & $oExcel & "]; error=[" & @error & "]." )

Exit

EndIf

MsgBox returns: "Returned=[0]; error=[0]

Windows 7 machine, Excel is 2010.

The AutoIt Help states:

Success: Returns new object identifier Failure: Returns 0 and set @error @error: 1 - Unable to create the Excel COM object 2 - $fVisible parameter is not a number

[water]

What operating system do you run?

32 or 64 bit?

What version of Office do you run?

32 or 64 bit?

What AutoIt version do you run?

Do you run your script as 32 or 64 bit?

[jdelaney]

Windows 7; 64-bit Operating System

Office Version: 14.0.6112.5000 (32-bit)

AutoIt v3.3.8.0...32v64? good question, no idea...I launch the scripts from my admin CMD, so whatever the default is for running a .au3...

there we go: C:Program Files (x86)AutoIt3AutoIt3.exe

Edited February 9, 2012 by jdelaney