Burgs Posted June 20, 2012 Share Posted June 20, 2012 Hello, This may be a stupid question but are the commands in the "Excel.au3" for usage only with the Excel program? I am running OpenOffice which can create and/or open Excel .xls files...however I cannot seem to open a .xls workbook, #include <Excel.au3> $oExcel = _ExcelBookOpen("C:\Program Files\Myfolder\Sample.xls") The error code thrown is "1"...indicating simply "Unable to create the object". The only thing I can figure is that I do not have Excel installed on my system and instead am using OpenOffice. Any verification of this appreciated. Thanks. Link to comment Share on other sites More sharing options...
AdmiralAlkex Posted June 20, 2012 Share Posted June 20, 2012 Yes, Excel.au3 requires Excel. It uses the Excel COM object. Can't remember any UDF for OpenOffice, but it's not included with AutoIt if there is one. Search Examples forum. .Some of my scripts: ShiftER, Codec-Control, Resolution switcher for HTC ShiftSome of my UDFs: SDL UDF, SetDefaultDllDirectories, Converting GDI+ Bitmap/Image to SDL Surface Link to comment Share on other sites More sharing options...
Burgs Posted June 20, 2012 Author Share Posted June 20, 2012 OK...thank you for confirming that. Link to comment Share on other sites More sharing options...
water Posted June 20, 2012 Share Posted June 20, 2012 Search the "Example Scripts" forum for "Open office calc" and you will find some UDFs () which might do what you need. My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki Link to comment Share on other sites More sharing options...
Burgs Posted June 20, 2012 Author Share Posted June 20, 2012 Thanks I will do that...regards 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