Macro on EXCEL to search strings on Webpage

[Asuryan39]

Good morning.

I found few post related to my question but none of the solutions worked for me (Maybe I did something wrong)

I have a long list (100') of webpages (https) and I need to update some of the content they may have.

So, I wanted a macro that takes all addresses from column A (Starting from A2) and search for all all strings present on Sheet 2 column A.
If search found nothing, I could have a "no result" on column B but if the macro found something, I would like to have a list of all string found in this particular page. (Could be on columns B, C, D, etc.)

Is it possible ?

 

[Dan_W]

It's certainly possible. There are two parts to this task:

1. Extracting the text from the website
2. Searching that text for each item on your list of words/phrases

Do you still need help with this? If so, what progress have you managed to make thus far?