+ 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, UK
    MS-Off Ver
    365
    Posts
    6,581

    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
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,741

    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!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    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.

  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,258

    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,258

    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
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,741

    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)

Similar Threads

  1. Replies: 10
    Last Post: 07-14-2015, 12:26 AM
  2. Replies: 0
    Last Post: 11-21-2014, 05:00 PM
  3. If Formula in date validity function
    By Janmarcus in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-05-2014, 09:22 AM
  4. Macro changing hyperlinks - Urgent help needed please
    By pj_vanherf in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2012, 12:42 AM
  5. Replies: 7
    Last Post: 06-14-2012, 09:44 AM
  6. [SOLVED] Formula which checks whether a string is found in a range and checks 2 criteria
    By liranbo in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-30-2012, 05:28 PM
  7. reduce code which checks for changes
    By khalid79m in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-28-2007, 11:33 AM

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