100Conrad Posted February 17, 2015 Share Posted February 17, 2015 I´m trying to use the new function _Excel_RangeRead in the updated UDF Excel.au3. It looks better than the old one but I can´t make it work. #include <Excel.au3> $oExcel = ObjGet("", "Excel.Application") ; Get an existing Excel Object $aArray = _Excel_RangeRead ( $oExcel,1 ,"C15:E20",1) MsgBox ( 1, "Titel", $aArray[1][1] ) I get the following error: "M:PonnyAutoitScriptsTest2.au3" (14) : ==> Subscript used on non-accessible variable.: MsgBox ( 1, "Titel", $aArray[1][1] ) MsgBox ( 1, "Titel", $aArray^ ERROR Can someone please help me out? Link to comment Share on other sites More sharing options...
water Posted February 17, 2015 Share Posted February 17, 2015 Welcome to AutoIt and the forum! Please have a look at the example for _Excel_RangeRead in the help file. It explains how the function needs to be used. 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...
100Conrad Posted February 18, 2015 Author Share Posted February 18, 2015 I checked the help file before writing in this forum and also tested the exemples. Worked fine but my first try didn´t. I´m just trying to read a range filled with numbers in a worksheet and test if I suceeded with the messagebox Link to comment Share on other sites More sharing options...
water Posted February 18, 2015 Share Posted February 18, 2015 The new Excel UDF doesn't work the same way as the old did. You need to call _Excel_Open: Start Excel or connect to an already running instance _Excel_BookOpen: To open an existing Excel file or _Excel_BookAttach to connect to an already opened Workbook _Excel_RangeRead in your case. 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...
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