Getting first search result link for given cell in excel using VBA?

I have a long list of names (about 8000) in an excel file that I need to find a linkedIn page for.

How to get full and correct URL from element?

I’m trying to find a way to get the correct and full URL of a link.