ie automation run-time error

**nkudeba** · 07-07-2013, 12:28 PM

Hello all,

I am trying to run a macro to search the string in column a into Google, retrieve the URL of the first search result, and place the resulting title and url into columns c and d, respectively. I retrieved the code for this macro from some answers site, but I understand the gist of it. The macro tends to work for a little while - say 40 rows - but then returns a run-time error. After the run-time error, if I stop the macro and immediately run again, the error will re-occur until I wait a certain amount of time. The error reads: "Run-time error '-2147024891 (80070005)': Access is denied." Is there a way to beat this error?

Please Login or Register  to view this content.

Thanks!

**Norie** · 07-07-2013, 12:43 PM

You seem to be creating a lot of objects and then not re-using them, dismissing them, setting them to Nothing.

I can only think that's going to mean that as the code runs you will be leaving a whole lot of objects just kind of floating about unused.

That might not be the root of the problem though, have you checked if you get the error you describe when you search on a specific term/terms or try and access a particular URL/page?

**nkudeba** · 07-07-2013, 12:57 PM

Thanks for your response.
Well I don't think it's a specific term/terms, because the code worked for the first 30-40 terms, then gave me a run-time error, but when I ran it again a couple hours later, the code continued on lines 40-60ish, then gave me another run-time error, and I ran it again until line 90ish. No specific search string seems to have given an error, but it seems after a certain amount of time sending the xml request, my access is denied...

**Kyle123** · 07-07-2013, 01:07 PM

It's possible that you are being blocked, automation of google searches in this way is strictly against their terms and conditions - it's possible that they therefore put a limit on the number of requests that you can make in a given time period

**nkudeba** · 07-07-2013, 01:20 PM

Hi Kyle, That does seems a plausible reason for getting denied access. However, I have made Google searches in IE immediately after getting the run-time error, with no such issue...

**Kyle123** · 07-07-2013, 01:39 PM

I suspect it's the frequency of requests, currently you are making requests as fast as vba allows, google doesn't like this, making a request then in internet explorer wil then have a different request profile and be much slower.