Count number of occurrences of text in URL

Hi guys,

Is it possible to look into a URL (that is placed in column A1 for example) and input the number of times a given piece of text appears in its' HTML (in column B1 for example)?

Any suggestions/advice/help will be very much appreciated .

Thanks

Hi,

Thanks for the help Sintek and Special-K but I think I may not have explained my problem properly. I don't want to look for something in the actual URL text. I need Excel to look into the contents of the URL and count how many times a particular piece of text is mentioned within the contents of that page - not within the URL string. I hope that makes sense.

Thanks

Originally Posted by sintek

Hi james19

Check out this link...Not sure if it can assist
http://stackoverflow.com/questions/1...l-in-excel-vba

Thanks for sending this link. Ive had a brief look and will look into it in more detail tomorrow. I also foubd this which may do what I need: https://www.import.io/post/how-to-get-live-web-data-into-a-spreadsheet-without-ever-leaving-excel/

Something like below? Note that it looks in .responseText in it's entirety and not what's displayed on web site as text.
Code also requires Windows machine.

Please Login or Register  to view this content.

See attached sample.

Hi CK76,

Thanks for the code but unfortunately it returns a runtime 429 error and says activeX object can't create object. The error is on the 'With CreateObject("MSXML2.serverXMLHTTP")' part of the code. I'm guessing this is because I'm using a Mac and as you said, this needs a Windows machine to run. Is there a way to change this code so it works on a Mac?

Thanks

To my knowledge, there isn't XMLHTTP/WinHttp equivalent in MAC.

You can try using WebQuery/QueryTables like mentioned in link.
http://stackoverflow.com/questions/1...excel-2011-vba
https://support.microsoft.com/en-us/...-excel-for-mac

Originally Posted by CK76

To my knowledge, there isn't XMLHTTP/WinHttp equivalent in MAC.

You can try using WebQuery/QueryTables like mentioned in link.
http://stackoverflow.com/questions/1...excel-2011-vba
https://support.microsoft.com/en-us/...-excel-for-mac

Cool thanks. I'll take a look at the links you sent and try to get your code working on Mac.

Here's one that might work better, using shell/MacScript.
http://stackoverflow.com/questions/1...a-for-mac-2011

Originally Posted by CK76

Here's one that might work better, using shell/MacScript.
http://stackoverflow.com/questions/1...a-for-mac-2011

Thanks CK76. It's starting to go above my level now but I'll have a look anyway.