Using VBA for extracting data from specific Google Searches

[cfc06]

Hello all,

I am looking for a code that uses the data in cells to do a Google Search and then resultantly extract the Address and Telephone of a company.

Upon some sample searches, I have found that the majority of these companies appear first time with the 'Business Details' box at the side of Google. This is the data I would like extracted into Excel.

Please let me know if anything is unclear and as always, I appreciate your help!

Many thanks.

[AB33]

Please attach an excel sample book with a desired result. Let's column A has the search items, columns B and C should show your desired out put for each search item on column A.

[cfc06]

Hi AB - thank you for replying. I have attached a sample.

Additionally, here is an image of where I would like the data to come from (if it helps)

KFC Example.JPG

[AB33]

Okay! Will do it after lunch.

[cfc06]

Thanks AB - I look forward to seeing it

[AB33]

I am unable to use HTTP object, so I settled down with IE, which is crap to be honest with you, but you can use until I find why my HTTP is not working. I have to include a 5 seconds wait unit it jumps to the next cell. Try it and see if it works on your actual data.
Your cursor has to be on the active sheet before you run the code.