I've been trying and trying to get this dang thing to run, but am at my wits end. Here is the file: https://sites.google.com/site/excelproblem001/
I am running a querytable on a loop of pages to collect a list of links and running a querytable on them. It will run fine and collect the data, but then ~30 records in it won't collect the data of the subquery. ~10 records later it will. Then it goes to the next page and errors out. Any help would be much appreciated!
I am running a querytable on a loop of pages to collect a list of links and running a querytable on them. It will run fine and collect the data, but then ~30 records in it won't collect the data of the subquery. ~10 records later it will. Then it goes to the next page and errors out. Any help would be much appreciated!
