Good Afternoon Everyone,

As this is my first time posting, please forgive me if I do not follow protocol. Also, I am a new learner of VBA so again, please forgive my ignorance. I do not pretend to have a clue with what I aim to achieve... nonetheless, I will try. On the the problem:

I would like to build a Macro in Excel which opens Google Maps and searches for content (which in this case is the company name) inside column F, and then saves the phone number of this company into Column G. The phone number of many companies pops up in the results.

Example of excel workbook :
Column F Phone number

Company A

Company B

Company C

Please Login or Register  to view this content.

If I might add - I have tried to open the developer while in google maps... the example image is of the object I want to save from google maps.Capture.PNG

thanks for your assistance.