+ Reply to Thread
Results 1 to 6 of 6

Hyperlink Status Check Win7 Home Premium 64Bit + Excel2010

  1. #1
    Registered User
    Join Date
    10-08-2014
    Location
    Berlin
    MS-Off Ver
    Office 2010
    Posts
    2

    Hyperlink Status Check Win7 Home Premium 64Bit + Excel2010

    Hi,

    as you can see in the title i want to check if hyperlinks are forbidden, not found/gone or unavailable atm
    i already know winhttp isnt working, i tried xmlhttp but the versions i tried didn't worked also

    in each worksheet is a button to the same macro (includes activesheet)
    in the columns from g to m i got hyperlinks (the cell shows normal text)
    for each of the most three internet errors the text i mentioned above shoul be recolored and the cell should get a comment
    for example it should do something like that
    error 503 should be colored in brown and the comment should be "Service unavailable at the moment"
    error 403 should be colored in purple and the comment should be "Forbidden"
    error 404 should be colored in red and the comment should be "Page not found"

    if anyone has a solution i would be pleased to get the permission to use it

    ps: i use win7 and excel2010 as you can see in title
    links for multi/crosspost
    http://computer.wer-weiss-was.de/vis...4bit-excel2010
    http://www.mrexcel.com/forum/excel-q...excel2010.html
    http://www.herber.de/forum/messages/1386607.html
    Last edited by Marzahn; 10-14-2014 at 08:07 AM. Reason: cross-post liks

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016
    Posts
    3,278

    Re: Hyperlink Status Check Win7 Home Premium 64Bit + Excel2010

    Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Registered User
    Join Date
    10-08-2014
    Location
    Berlin
    MS-Off Ver
    Office 2010
    Posts
    2

    Re: Hyperlink Status Check Win7 Home Premium 64Bit + Excel2010

    I'm sorry for breaking the rule, this place was the first one for my posting, on next posting i will do it only in one place, i linked the other forums and withinin the other forums are now links too

  4. #4
    Registered User
    Join Date
    10-17-2014
    Location
    Chesterfield, Derbyshire
    MS-Off Ver
    2010
    Posts
    2

    Re: Hyperlink Status Check Win7 Home Premium 64Bit + Excel2010

    I found that using GET caused a problem, the pages where taking too long to open. All of my links are PDFs so I sent a post which resulted in 405 (Method not allowed) or 404 )Not Found). Therefore I could assume 405 pages exist meaning I could check the links faster.

    NB E4 is the top of the 196 links and I will never have more than 200 links so hard coding 200 is OK in this case.

    Please Login or Register  to view this content.
    Last edited by dntaker; 10-17-2014 at 07:08 AM. Reason: Code Tags

  5. #5
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,149

    Re: Hyperlink Status Check Win7 Home Premium 64Bit + Excel2010

    Changing POST to HEAD is probably more reliable

  6. #6
    Registered User
    Join Date
    10-17-2014
    Location
    Chesterfield, Derbyshire
    MS-Off Ver
    2010
    Posts
    2

    Re: Hyperlink Status Check Win7 Home Premium 64Bit + Excel2010

    Perfect even faster, Thanks Didn't see the HEAD option when looking this up for the first time. Awesome!
    HTML Code: 
    <a href="www.eriks.co.uk">ERIKS</a>

+ 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. Formula to Convert Gross Insurance Premium to Net Insurance Premium
    By jaguar1317 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-19-2014, 08:18 PM
  2. Change registry settings for IE 64bit in 64bit environment
    By dgdgdg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-30-2014, 07:56 AM
  3. DSN Creation doesn't work in win7/Excel2010
    By apratsunrthd in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-10-2013, 02:41 PM
  4. Replies: 3
    Last Post: 11-23-2012, 01:57 AM
  5. Replies: 4
    Last Post: 11-28-2009, 07:53 AM

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