HI every one, I am just beginner of VBA excel macro programming. I seen this post
http://www.excelforum.com/excel-prog...or-phrase.html and it helped me but it is different from which i want . in my case I have a large list of web hyperlinks . i want to find some specific words or phrases from web pages such that when i run the macro it do the following steps
step 1-ask user to select a range of hyperlinks from column A
step 2-without opening any webpage check all websites slected in step 1 and find the words which I given inside the code. e.g "title", "name","expired
step 3-if the word is found simply write result as yes or no in next coumn. i.e if word "title" is found the write yes in column B, if name is found then write yes in C. and so on according to number of words. you can see the attached file for understanding.
step 4- search should not b case sensitive i.e result for "title", "Title" or "TITLE" etc should b same.
I found a bit little same code but can't understand it in details this code woks but gives wrong result i.e a webpage actually not have some searched keyword but it returns yes for that key word. you can see the attached file where i mentioned the wrong results given code. also for this given code it is case sensitive so for single keyword i have to make multiple searches for upeer, lower or proper case. see the attached file in column G i explained the problem.Kindly see it as soon as because these are my posts on diferent websites which may expire after some days so maybe you can't see .but is you not found any of them i will give you more fresh posts.
kIndly advise me for learning VBA excel macro programing and also suggest some good and short book for it.
Bookmarks