Return a word count from a webpage/html for a list of words using VBA

[Dschiavo01]

Hi All, first post, let me know if I can provide additional details and I will try.

I want to search a webpage for a list of words working down a column and return a count of how many times each word appears on the webpage. Thus far I've only been able to figure out how to search the page and return if the word exists at all, see below. I am a novice user of VBA as an FYI.

Thanks!

If InStr(URL, Ticker) = 0 Then
ActiveSheet.Range("B2").Value = "Not Found"
Else
ActiveSheet.Range("B2").Value = "Found"
End If
Exit Sub

 

[Dschiavo01]

Hi, the above macro will count the number of words in the URL not on the page. The code you shared was trying the same thing and hence modified the same.

Would you like to count the words in the page?

Yes, the goal is to count the words on the page (not one total, return a count of individual an word or words from a list in a column) that the URL opens. I’ve tried both opening the page and counting the words and trying to have VBA look to the HTML where most of the words are imbed with no luck, it just keeps reading the URL itself.

 

[Dschiavo01]

Hi, the above macro will count the number of words in the URL not on the page. The code you shared was trying the same thing and hence modified the same.

Would you like to count the words in the page?

Yes, the goal is to open the webpage and count the words within the webpage itself.

-It doesn't need to open the webpage if there's a way to code around that.
-I've poked around at reading the HTML or exporting and then reading the HTML export as well without success, but just throwing that out there in the event it's useful as an idea.

sorry for double reply, it didn't show the other reply posting, and I'm not sure how to delete lol

 

[Dschiavo01]

Hi, the above macro will count the number of words in the URL not on the page. The code you shared was trying the same thing and hence modified the same.

Would you like to count the words in the page?

Yes, the goal is to count the words on the page, but not just the total words. The goal is to return a count by word for a list of words in a column in the excel file.