+ Reply to Thread
Results 1 to 4 of 4

find broken links

  1. #1
    Registered User
    Join Date
    08-27-2020
    Location
    Mexico
    MS-Off Ver
    16.0.4266.1003
    Posts
    1

    Question find broken links

    Good Afternoon, I have a big file with a lot of links.
    Is there a way to know wich of them are broken links (error 404) without clicking on each and every link in the file?
    Last edited by Focus_Draco; 08-27-2020 at 04:21 PM. Reason: add an example

  2. #2
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: find broken links

    NOPE, there isn't. how could there be!? the links are sitting in a local file, and that's not a browser window. you can, however, view webpage URLs in a control that is offered by ms access, and possibly ms excel, called the webViewer Control. I think it's in the ActiveX category.

    the other thing you might try, which is wayyyyy out there, is automating a DOS process whereby you loop through all of your links, throw it to a DOS command and try to ping the server at that ip address (web address) to see if you get a response. if you don't, then obviously it's broken!

    and if you have serious programming skills, I would be $100 USD that Python and/or C/C++ could do exactly what you're trying to do. but that's very low-level work.

  3. #3
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Arrow Re: find broken links

    Quote Originally Posted by Focus_Draco View Post
    Is there a way to know wich of them are broken links (error 404) without clicking on each and every link in the file?
    Hi,

    it's possible under VBA by applying some web requests - many samples in forums - and checking their status
    or just piloting IE but lasts a lot more than requests …

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: find broken links

    Quote Originally Posted by vba_php View Post
    NOPE, there isn't. how could there be!?
    Well, there could be if you know VBA. That was a hasty answer. You can simply send HTTP page requests and see what comes back.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Delete broken/obsolete links from the 'Links' manager
    By LeaIngemann in forum Excel General
    Replies: 0
    Last Post: 07-01-2015, 09:16 AM
  2. Sort through list of links to find broken ones
    By Bailey_Thomas in forum Excel General
    Replies: 2
    Last Post: 01-22-2015, 02:20 PM
  3. Find the broken links
    By anaibis12 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-19-2014, 07:03 PM
  4. Find All Broken Links?
    By thumbs21 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-15-2013, 09:59 AM
  5. All teh links are broken!
    By paulg87 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-05-2013, 10:11 AM
  6. Broken Links
    By jamesmjr in forum Excel General
    Replies: 2
    Last Post: 12-30-2009, 01:19 PM
  7. [SOLVED] Broken Links
    By David in forum Excel General
    Replies: 3
    Last Post: 06-30-2005, 10:05 PM

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