Need to fetch URL destination from hyperlinks

[excelhatesme2017]

Greetings, I have the following problem:

I have a list of about 10k URLs with links to different sites, for example:

1	https://www.google.com
2	https://www.yahoo.com
3	https://www.bing.com

Now, obviously, all of the links lead to a page which has a name (google, yahoo, bing, etc.) displayed in browser tabs:

zIJyc6b.png

Is it possible to somehow fetch those very names via Excel functionale? What VBA functions should I try to use?

Thanks in advance

[Leith Ross]

Hello excelhatesme2017,

Welcome to the forum!

This macro will return the title for each URL in your list. Then macro starts at cell "A1" on the ActiveSheet and goes down to the last URL in the column.

If the URL is opened successfully then the title is placed to the right of the URL in column "B". You can interrupt the loop by pressing the keys CTRL+BREAK.

Add a new VBA Module to your VBA Project. Copy and Paste the code below into the new Module.

Please Login or Register  to view this content.