Macro for checking if articles are online in an onlineshop or if a 404 error code appears

[juliewessels]

Hi I have a list with a lot of URL adresses of articles where I would like to check if the articles are actually in a specific onlineshop or if a 404 error code appears. It would be great if excel would show the value 0 if the article is online or the value 1 if an error accurs.
Here is an example:
https://www.douglas.de/p/M1202036 --> shows me an error
Acetyl-L-Carnitin --> shows me the product.

If someone could help me would be amazing. I'm trying to find a solution for many hours...

Thank you so so much!!