Jump to content

Recommended Posts

Posted

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
Posted

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.

My UDFs and Tutorials:

  Reveal hidden contents

 

Posted

appreciate the response, yeah, it has been some time since I updated 😕

I will give that a go, thanks!

Posted

Another good read is the wiki 🙂 

My UDFs and Tutorials:

  Reveal hidden contents

 

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
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...