1. don't give lots of invalid numbers. it will block your access for 24 hours.
2. you will have to delete or rename SRC01-244 sheet out of you excel file everytime you run a new one.
If you have run it once u know the valid numbers within that range. If some of you programmers out there could edit the script so that the next time you query ONLY for those valid numbers by looking up another worksheet with those numbers in excel, then you will be ok.
Similar thing happened to me. I ran this script from work (I don’t know the speed) but it is pretty fast and saw very few results and sometimes no results. When I ran it at home 56K I got the correct results.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.