nnps Posted March 17 Posted March 17 I am attempting to create an array from two separate cells not next to each other (row 3 and row 6). Is there any way to read these in as a concatenate or do I need to merge the two cells first within excel? I prefer to use something like below, which I know is not correct on the (3,6) part. I can get the script to run just fine using just one row. Anyone know what I can put in the (3,6) section below to achieve this? _excelreadarray($oexcel, $schadrtrimbeg, (3,6), $numofrowsforschadr, 1, 0) Thanks!
Solution water Posted March 17 Solution Posted March 17 Seems you are running a quite old version of AutoIt. The Excel UDF has been rewritten some years ago. Means: A lot of functions have been removed, renamed or changed. Details can be found here. I suggest to use two calls to _Excel_RangeRead and assign the result to your array. Musashi 1 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
nnps Posted March 17 Author Posted March 17 appreciate the response, yeah, it has been some time since I updated 😕 I will give that a go, thanks!
water Posted March 17 Posted March 17 Another good read is the wiki 🙂 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
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