Macro to check websites ?

[wonderd]

Hello everyone. Is is possible to make macro that can go down list of websites on excel file in Column A and determine if website has a blog and then in Column B script will write Yes or No ?

 

[Rijnsent]

Hi wonderd,
something in that direction can be done: you can use VBA to visit websites and e.g. check if the word "BLOG" appears somewhere on that site. To get you started some links for VBA/excel web scraping:
https://www.myonlinetraininghub.com/web-scraping-with-vba
http://www.excelvbasolutions.com/2014/08/web-scraping.html
http://dailydoseofexcel.com/archives/2011/03/08/get-data-from-website-that-requires-a-login/
Cheers,
Koen

 

[Kyle123]

xposted here: https://www.excelforum.com/excel-pr...-macro-to-scan-websites-on-list-for-blog.html