VBA code to copy all URL addresses from a web page

[chin67326]

Hello, please see the attached file. On Sheet1, if you click the 'Open Userform' button, you will get a userform [duh - lol]. I want to be able to enter a URL [e.g. https://www....etc.] and then click the 'Copy all URLs...' button and have each and every link/embedded link found on that webpage listed in column A of Sheet1 in the attached file.

Your assistance to write the code for the command button will be appreciated!

[ByteMarks]

Perhaps using HTTP request?

Please Login or Register  to view this content.

[chin67326]

Thanks ByteMarks! It works well on some webpages but on some pages I get no data back but instead get the below error:

The system cannot locate the resource specified

The links I am trying to obtain from the webpages don't necessarily start with the usual https:// and some are just sentences or words on the page that have a hyperlink and when you click on the words or sentences they send the user to that page.