Checking for broken hyperlinks

Good morning all,

I am putting together a document where often the numbers have to be justified by some form of supporting document, often in .pdf format. To be as user friendly as possible I hyperlink those numbers to said document. Unfortunately that means there are a lot of hyperlinks and mistakes get made!

So my question is, is there a way to automatically check the entire document to ensure none of the links are broken, and if there are broken links, which ones they are? Thanks in advance!

Chris

Assuming the hyperlinks refer to documents on your network...
Try this

• Select any sheet in the workbook you want to test
• ALT+F11....to open the VBA Editor
• Insert.Module
• Copy the below code and paste it into that module

Please Login or Register  to view this content.

• Select a sheet that contains hyperlinks you want tested.
• Select the range of cells that contains the hyperlinks....eg A1:Z100
• ALT+F8...to open the list of availlable macros
• Select: TestHLinkValidity
• Click: Run

Any hyperlinks with invalid targets will be colored yellow.

Is that something you can work with?

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

Also, for confirmation, I believe Ron's code is for documents on a network. If you are at URLs then there is other code for this. It was not clear from your post which you were trying to check.

PM me if you have any problems.

abousetta

ryan_linz,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

This cleaner version will fix it. Ron just forgot to use the entire path. Looks like caused by copying only portions of another code (hence the superfluous variables). Good algorithm though.

Please Login or Register  to view this content.

Solved it,

Welcome to the forum and thank you for the solution.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.

Try this

Please Login or Register  to view this content.

Danialadam,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.

After you press Atl+F11, on the left hand side you will Microsoft Excel Objects. Right click on it and select Insert - > Module. On the right hand side you will see a blank code window. Copy paste your code over there.

Corey123,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

chrisfreire,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

For me the previous examples continue to highlight all of the hyperlinks, not just the broken ones.
This is what worked for me after adding a reference to Microsoft WinHTTP Services under Tools > References:

Please Login or Register  to view this content.