Get the first result details (title, description, URL) from google search of a keyword and return re-CodePudding

I have been trying to search for a keyword in google through excel VBA and return results like title, URL and description of FIRST RESULT ONLY to Sheet1 of the excel file. My keywords are in range A1:A3 and I want

Titles to be populated in B1:B3
URL to be populated in C1:C3
Description to be populated in D1:D3

I have tried the code provided in

I will be using Internet Explorer for this thing.

Please keep in mind i have little to no knowledge of HTML and I am doing this scraping stuff for the first time so please be very clear in your description about elements.

CodePudding user response：