Okay, so it has been reported that the earnings and the total queries do NOT account for all questions, and I had thought maybe ChaCha's pages didn't load, but I was WRONG! It turns out that it was due to my own stupidity, in forgetting to account for the header rows for each column. So the headers that were pasted into Excel would "overlap" the last entry of the previous page.
I will include this fix for the next version, but if you need a quick fix, you can do the following:
On Excel, go to Tools>Macro>Macros
Select ChaChaGrabHistory, Click Edit
Scroll down to the the following line: (Its a bit past halfway)
Destination:=Range("A" & 1 + ((i - 1) * 15)))Replace the 15 by 16. You should result in:
Destination:=Range("A" & 1 + ((i - 1) * 16)))And that's it!
Thanks for joining me in my journey of how to program! Until next time!
people have found my page useful (hopefully!).
1 comment:
Thanks!
I am having trouble DLing my questions, but I think it is because the system is sluggish and behind and it just can't connect to retrieve the info. I will try again in a little while.
You were right :) there were other sheets at the bottom lol. This is only my second experience with an Excel document, the first was a spreadsheet to keep track of question totals and money earned. It also had pages tabbed at the bottom and I couldn't figure it out at the time either. I think with the spreadsheet I am using right now and with this tool you have made, I will have all the records I need for tax time!
Thanks again!
Post a Comment