VBA macro for Google search

Hi all!

I am trying to modify a VBA macro for Google search. I want the output in excel to be the number of results (hits on Google). I have tried to change the element within the macro to "resultStats" but I keep getting bugs when I am trying to run it. The macro was at first made to gather weblinks for Google, which works perfectly.

So I though I only had to change the element in the script but this doesn't work.

Underneath I have attach the excel file with script.

Hope someone have an answer to my problem.

There is no element called resultStats and hence for the error. You are doing a fizzy search. If you look at the first URL,
https://www.google.co.in/search?q=Monkey&rnd=3648
it opens Google's home page, but not a specific page within Google.

I am not sure that I understand what you mean @AB33

I want to open Google as https://www.google.co.in/search?q=Monkey&rnd=3648 and then copy the number of hits into excel. Does it make sense?

Yes, however, I have overcome this problem. Thus, I still have a problem when there is no results in a search on Google. Any ideas?

I have attached a new file.

/Thanks

Very helpful

/Thanks!

Hi,

Please can you help me to apply some changes in attached macro.
Macro give the result as "About 36,30,00,000 results (0.46 seconds) " and I wan't to get first result.