Sign in to follow this  
Followers 0
jdelaney

_ExcelBookOpen False Negative? 2010

7 posts in this topic

#1 ·  Posted (edited)

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 by jdelaney

IEbyXPATH-Grab IE DOM objects by XPATH IEscriptRecord-Makings of an IE script recorder ExcelFromXML-Create Excel docs without excel installed GetAllWindowControls-Output all control data on a given window.

Share this post


Link to post
Share on other sites



What version of AutoIt do you use?


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

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


IEbyXPATH-Grab IE DOM objects by XPATH IEscriptRecord-Makings of an IE script recorder ExcelFromXML-Create Excel docs without excel installed GetAllWindowControls-Output all control data on a given window.

Share this post


Link to post
Share on other sites

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


IEbyXPATH-Grab IE DOM objects by XPATH IEscriptRecord-Makings of an IE script recorder ExcelFromXML-Create Excel docs without excel installed GetAllWindowControls-Output all control data on a given window.

Share this post


Link to post
Share on other sites

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?


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

#7 ·  Posted (edited)

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 by jdelaney

IEbyXPATH-Grab IE DOM objects by XPATH IEscriptRecord-Makings of an IE script recorder ExcelFromXML-Create Excel docs without excel installed GetAllWindowControls-Output all control data on a given window.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0