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.
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.
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
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.
BadlySpelledBuoy: looks like it did attach the spreadsheet.
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" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
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.
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!)
Leith Ross I tried running the code, but I got a "Run-time error '429': ActiveX component can't create object".
Any idea why?
It is highlighting this section Set MSXML = CreateObject("MSXML2.XMLHTTP")
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?
Microsoft Excel for Mac
version 16.33
Please update your forum profile with this information.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks