Extracting Hyperlinks from URL

[ScabbyDog]

Is there a macro that you will point at a URL and it will list all the URL's found on this specific web page.

[ScabbyDog]

Can't find much help online. Anyone know of a macro for this?

[Leith Ross]

Hello ScabbyDog,

This macro will list only the HTPP and HTTPS links for the given URL. It will not search deeper than the given URL's page.

Macro to List Hyperlinks on a Web Page

Please Login or Register  to view this content.

Example of Calling the Macro

Please Login or Register  to view this content.

[ScabbyDog]

Thanks Leith.

The link of the site I'm trying to scrape is http://www.sarugby.co.za/results.asp...&fullview=true

YOu'll see there that the scores of each game is a link, but for some reason your macro above does not return these URLs but it returns all other URLs.

[Leith Ross]

Hello ScabbyDog,

Sorry for the long delay. I am still having issues with posting messages, PMs, and attachments. It apeears I can only send text. For some reason somewhere in the IP chain, I am being blocked for some unknown reason.

I have the code working but can not post it here. You can download the sample workbook from my MediaFire account.

Here is the link: https://www.mediafire.com/?pb8bcz4qap45zph

[ScabbyDog]

Thanks Leith. Strangely I am blocked from MediaFire on my IP but will be at a different IP tomorrow so can download it then - unless some kind Forum member would do me the favour of downloading the mediafire link above and posting it within this thread?

[Leith Ross]

Hello ScabbyDog,

This just keeps getting better. Still no joy on my end.

[ScabbyDog]

Got it. Works perfectly. Thanks!

[Leith Ross]

Hello ScabbyDog,

You're welcome. After 2 1/2 days, I am still not able to post code or attachments. Makes my job so much easier.