Excel VBA that finds the stock name of a company by searching the stock ticker

Good day, everybody

I hope everybody is ok, thanks for welcoming to this group.


If possible and someone can help making an Excel VBA that finds the stock name of a company by searching the ticker.


Example

Cell B1 = AMZN
Cell C1 should show the full name of the company, in this particular case cell C1= Amazon.com Inc

Thanks in advance.