I am wanting to loop through a list of search terms and find out how many hits each one produces in google. I thought it was my lucky day when I found an article at http://www.eggheadcafe.com/tutorial...fe-7764a1096708/how-to-get-google-search.aspx which described exactly what I want to do.
<o
> </o
>
However, I can’t get the code to run.
<o
> </o
>
I’ve tried this both at home and at work but the send method always generates an error:
“Run-time error -21466977211 (800c0005)
The system cannot locate the resource specified.”
<o
> </o
>
Does anybody know what is causing this? I’m really out of my depth here as I’ve never worked with the MSXML2.XMLHTTP object nor do I know anything about it. A web search suggested that using Microsoft.XMLHTTP might be better than MSXML2 but I get exactly the same result.
<o
> </o
>
I’d appreciate any suggestions regarding this particular problem or indeed any alternative solutions for how to send a query to google from within Excel vba and then pull out specific information.
<o
> </o
>
Regards
HedgePig
P.S. Am using Office 2007 and Windows XP.
<o


However, I can’t get the code to run.
Code:
search_url = "http://www.google.com/search?hl=en&q=" & searchWords & "&meta="""
Set search_http = CreateObject("MSXML2.XMLHTTP")
search_http.Open "GET", search_url, False 'This seems to work
search_http.send 'The send method fails.


I’ve tried this both at home and at work but the send method always generates an error:
“Run-time error -21466977211 (800c0005)
The system cannot locate the resource specified.”
<o


Does anybody know what is causing this? I’m really out of my depth here as I’ve never worked with the MSXML2.XMLHTTP object nor do I know anything about it. A web search suggested that using Microsoft.XMLHTTP might be better than MSXML2 but I get exactly the same result.
<o


I’d appreciate any suggestions regarding this particular problem or indeed any alternative solutions for how to send a query to google from within Excel vba and then pull out specific information.
<o


Regards
HedgePig
P.S. Am using Office 2007 and Windows XP.