+ Reply to Thread
Results 1 to 7 of 7

Broken Hyperlinks (lots in one sheet)

  1. #1
    Registered User
    Join Date
    10-31-2011
    Location
    Austin, Tx
    MS-Off Ver
    Excel 2010
    Posts
    5

    Unhappy Broken Hyperlinks (lots in one sheet)

    I have a sheet (attached) with roughly 22,400 hyperlinks that go to reviews on products. The problem is the person that created this sheet didn't have a plan for products that are removed from the web. So, needless to say there lots of links in here that lead to 404 web errors as the pages no longer exist. Is there a Macro or Formula I can run to have it ping all of these hyperlinks for a 404 or other error if the webpage no longer exists? I deleted all but about 250 of the links so you could see a subset of what I am working with in the attachment.

    Thanks,
    Jason
    Attached Files Attached Files

  2. #2
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Broken Hyperlinks (lots in one sheet)

    Please Login or Register  to view this content.



  3. #3
    Registered User
    Join Date
    10-31-2011
    Location
    Austin, Tx
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Broken Hyperlinks (lots in one sheet)

    Quote Originally Posted by snb View Post
    Please Login or Register  to view this content.
    I added this as a module under VBA. I ran it, but it didn't seem to do anything. I suspect it was supposed to delete an invalid URL, but take lin 89 for example - I get a 404 error, yet it didn't delete it. Thoughts?

  4. #4
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Broken Hyperlinks (lots in one sheet)

    Please do not quote (see the forum rules ).

    You'd better put this into the macromodule of the sheet that contains the hyperlinks.

  5. #5
    Registered User
    Join Date
    10-31-2011
    Location
    Austin, Tx
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Broken Hyperlinks (lots in one sheet)

    snb. Thank you for the help. I did create it as a macro within the spreadsheet I am working, but it still seems to be unresponsive. Any ideas what I might be doing wrong?

  6. #6
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Broken Hyperlinks (lots in one sheet)

    I hope you put it into the right sheet module.
    Well, you have to run the code (alt-F8)

    After that the only thing that is noticeble in the sheet is that certain links lack the understrike and have another colour.

    You can post a sample workbook (containing 1 sheet and only a few rows containing hyperlinks and the macro).
    Last edited by snb; 11-01-2011 at 12:28 PM.

  7. #7
    Registered User
    Join Date
    10-31-2011
    Location
    Austin, Tx
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Broken Hyperlinks (lots in one sheet)

    I was definitely running the code, and as I am pretty new to Macros/VBA I suspect I am simply inserting it wrong. I have attached a sheet with the Macro as you requested and deleted remaining sheets.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1