getrows trouble

So I have the following code:

Please Login or Register  to view this content.

I Deleted some random stuff from the above as it doesnt pertain to anything other than finding the correct target range and the path of the files etc but I left everything that has to do with my connection to another file along with where Im running into trouble which I bolded...

Please Login or Register  to view this content.

If I substitue in for the bolded part the code above everything works fine... I get multiple results printed out to my spreadsheet... however if I use the original code I only seem to get 1 result to the spreadsheet... Any idea why that is? My goal is to get rid of the spreadsheet part and have a array variable that I can work with later


Thanks.

May be:

Please Login or Register  to view this content.

hey it works thanks! It grows horizontally which was unexpected easily fixed with transpose


That will be enough for most of what I need to do, however there is 1 part of my project I havent yet figured out..

I would need to take that array and use its results to run more queries, then report those answers

So for instance if I ran Query 1 and it said the results were A , B , C

I then would need to run a Query on A to see what it breaks down to ... say a,b,c Then B for d,e,f and C for g,h,i

Then instead of listing to my spreadsheet A,B and C i would instead see a,b,c,d,e,f,g,h,i

I have a few ideas on how I may achieve this but honestly they will be overly complex, and thats assuming they work at all which is not likely.... so I figured why not ask to see if any of you guys had any elegant solution for that, I realize I can use a lot of spreadsheets for each step but Id rather take a minimalist view when filling the actual cells with data as in Id love to only have to fill the cells with the end results.


Thanks Again!

After you run Query1 - just keep result of it in some variable/array and then take A - run query and print out the result a,b,c. Then take B, run query and print out the result under already extracted,to get a,b,c,d,e,f. and so on.
You could write a function with parameter to get query resutls and then just pass those A, B, C as parameters.

Ok I ran into 1 problem... Some of the Variables I run through my getrows function have multiple columns in the original table so if I query to select multiple things only 1 column returns...

So I did this:

Please Login or Register  to view this content.

Which I found all over google as a way to fix that problem... Only I get a Run-Time Error '-2147217884 ( 80040e24 ) Rowset does not support fetching backward

So why am I getting this error when according to a lot of the internet, that is what I need to do to be sure I get all of my records into my array?