Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Checking Hyperlinks
Hi all, my name is Nev and this is my first post to your forum.
I have a spreadsheet (2007) with two columns of hyperlink's which i need to check. The spreadsheet contains products for Google's Merchant Centre, and I know that 5,000 links don't work and I need to find our which ones. I noted the following thread https://www.excelbanter.com/excel-discussion-misc-queries/120564-re-checking-hyperlinks-valid.html which shows a VBA code, I have copied and pasted this code, but when I run the macro I get an error ever time "Bad file name or number". I assume that the code may need changing for my individual use, but I have no VBA experience and thus cant see what the issue might be. Any help appreciated Nev |
#2
|
|||
|
|||
Quote:
|
#3
|
|||
|
|||
Hi Nev,
If you attach your file it will make it far easier for someone to help. S. |
#4
|
|||
|
|||
Quote:
Nev |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
checking hyperlinks are valid | Excel Discussion (Misc queries) | |||
checking hyperlinks are valid | Excel Discussion (Misc queries) | |||
checking hyperlinks are valid | Excel Discussion (Misc queries) | |||
checking hyperlinks are valid | Excel Discussion (Misc queries) | |||
Excel VBA - Checking for inactive hyperlinks | Excel Programming |