jdelaney Posted February 8, 2012 Share Posted February 8, 2012 (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 February 8, 2012 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. Link to comment Share on other sites More sharing options...
water Posted February 8, 2012 Share Posted February 8, 2012 What version of AutoIt do you use? My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
jdelaney Posted February 8, 2012 Author Share Posted February 8, 2012 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. Link to comment Share on other sites More sharing options...
jdelaney Posted February 8, 2012 Author Share Posted February 8, 2012 I should have done IsObj to validate the object 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. Link to comment Share on other sites More sharing options...
jdelaney Posted February 9, 2012 Author Share Posted February 9, 2012 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. Link to comment Share on other sites More sharing options...
water Posted February 9, 2012 Share Posted February 9, 2012 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 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
jdelaney Posted February 9, 2012 Author Share Posted February 9, 2012 (edited) Windows 7; 64-bit Operating SystemOffice 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 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. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now