LinkBack URL
About LinkBacks
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!
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.
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 Starbelow 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)
Posting Permissions
Register To Reply
Bookmarks