Searching for specific elements from website source code in VBA

Hello,

I am looking for specific elements in the website source code in VBA.

The set-up is as follows:

In the range A:A I will put a list of urls. Every URL needs to be checked for specific elements.For example when there is a hit with the word "beer"or "erotic" in the source code of the webpage the macro needs to generate a signal. Most of the websites will not give a hit. Every url needs to be checked. When there is a hit with one of the words this is enough for a hit. It will be wonderful when the hit leads also to categorization. when there is a hit with the word beer it has to categorize the url in the category "alcohol" and "erotic" in
category 18+.

This is just simple version. I have a lot of keywords and also a lot of categories.

Is this even possible?

I am looking forward for your suggestions. I am pretty new to VBA. But I think this is they only way to optimize.

Hi !

Yes it seems doable, all depend of the real workbook layout …