+ Reply to Thread
Results 1 to 11 of 11

Need VBA code or Function that checks validity of jpg hyperlinks

  1. #1
    Registered User
    Join Date
    02-15-2020
    Location
    ca
    MS-Off Ver
    10
    Posts
    7

    Need VBA code or Function that checks validity of jpg hyperlinks

    I have a spreadsheet that has thousands of hyperlinks to product images. I need a function or vba code that will check each link to see if it is valid or returns a 404 error, etc.
    Last edited by AliGW; 02-16-2020 at 03:33 AM. Reason: Irrelevant section of title removed.

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex
    MS-Off Ver
    365
    Posts
    5,360

    Re: Need VBA code or Function that checks validity of jpg hyperlinks

    Is this a spreadsheet or a database? It says spreadsheet, but you've posted in the Access forum section...

    Could you attach a sample file so we can see the data layout. Far easier to help that way.

    BSB

  3. #3
    Registered User
    Join Date
    02-15-2020
    Location
    ca
    MS-Off Ver
    10
    Posts
    7

    Re: Need VBA code or Function that checks validity of jpg hyperlinks

    It is a spreadsheet. Looks like I posted this in the wrong forum. Are you able to help?

    The forum will not allow me to paste the links or a file. Going to try sending a private message.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    02-15-2020
    Location
    ca
    MS-Off Ver
    10
    Posts
    7

    Re: Need VBA code or Function that checks validity of jpg hyperlinks

    BadlySpelledBuoy: looks like it did attach the spreadsheet.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Office 365 (Win 10 - Work) & Office 365 Subscription Insider (Win 10 - Home)
    Posts
    35,626

    Re: Need VBA code or Function that checks validity of jpg hyperlinks

    This thread has been moved to the correct section of the forum.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  6. #6
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Need VBA code or Function that checks validity of jpg hyperlinks

    Hello GUEST_001,

    I have added a button to the worksheet to run the macro. The code and button have been added to the attached workbook.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  7. #7
    Registered User
    Join Date
    02-15-2020
    Location
    ca
    MS-Off Ver
    10
    Posts
    7

    Re: Need VBA code or Function that checks validity of jpg hyperlinks

    Leith Ross I tried running the code, but I got a "Run-time error '429': ActiveX component can't create object".

    Any idea why?

  8. #8
    Registered User
    Join Date
    02-15-2020
    Location
    ca
    MS-Off Ver
    10
    Posts
    7

    Re: Need VBA code or Function that checks validity of jpg hyperlinks

    It is highlighting this section Set MSXML = CreateObject("MSXML2.XMLHTTP")

  9. #9
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Need VBA code or Function that checks validity of jpg hyperlinks

    Hello GUEST_001,

    It is probably related to your OS. You don't have that information listed in your profile - you should update it. What version of Windows and Office are you using?

  10. #10
    Registered User
    Join Date
    02-15-2020
    Location
    ca
    MS-Off Ver
    10
    Posts
    7

    Re: Need VBA code or Function that checks validity of jpg hyperlinks

    Microsoft Excel for Mac
    version 16.33

  11. #11
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Office 365 (Win 10 - Work) & Office 365 Subscription Insider (Win 10 - Home)
    Posts
    35,626

    Re: Need VBA code or Function that checks validity of jpg hyperlinks

    Please update your forum profile with this information.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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