Simplest way to save the Quantity of Google searches found into Excel

[KiwJohn]

Hello from a chilly wet New Zealand,

I'm new to this forum and am asking for some advice to point me in the right direction.
I'm not a programmer but I've been learning some VBA programing skills over the years by trial/error and researching the web.
Normally I can find partial VBA solutions, tweak them and glue them together to do what I need but I'm struggling with the latest challenge which is my first time trying to scrape data from a website into Excel.

In Column A I have a list of Google exact search phrases, typically 200-500 items.
I want to write VBA code that will automatically search through this list and return the number of results found into the adjacent column.
For example, for Purple Elephants I manually enter the exact phrase "Purple Elephants" into Google and it returns the results page with a total number of results found being 91,600.

I want it to look like this....
Column A Column B
Purple Elephants 91,600
Blue Bananas 79,900

I did find some code on the internet, see attached, that I edited to get it running on my PC but all results come back as 0.

This is my first foray into trying to extract data from a browser so out of my depth in that respect.

I'm on Windows10 64-bit, using Microsoft 365 and have Chrome and Edge browsers installed.

After digging further I'm found references to Selenium for compatibility with Chrome.

Do I have to go down the Selenium pathway or is there another way I can get what I want, maybe using a different browser but without Selenium?

I'd appreciate hearing from you if you can point me in the right direction.

Thanks.
John

[dangelor]

Not sure if this is what you're looking for, but this change copies results to the worksheet...

Please Login or Register  to view this content.

[KiwJohn]

Yes, this did copy results to the worksheet for me, thank you.

I did a test using a small list of 15 items I'd manually checked previously.
Some of the results matched my previous results and 80% of them were within 20% of previous results.
However, 20% of them different by thousands of percent and the problem is I wouldn't know which 20% that is unless I had done a manual check previously which defeats that whole purpose.

I tried a different list of search terms and ran the macro to see if I could get any insights into the differences.
Unfortunately, the results from the macro are now all zeros, and it's the same when I put back in my original list of search terms.

I don't understand how this can happen.

Perhaps there is a Google limit on the number of searches it allows using scraping.
I only ran the macro about 6 times before it hit this snag.

Any thoughts why this could be?

I

[dangelor]

Not all that familiar with web scraping, but maybe you need to put a delay in the code. It might be reading the results before they are 'published'.