samuelimtech
05-22-2014, 04:26 AM
Hi all first of all thanks for the help.
Basically I have a list of 500 or so links (all in column A sheet1)
what Im after is a piece of code that will open them one at a time, search the page for a specific word ("local authorit", mispelt on purpose) if the word is found then highlight the link cell any colour.
the way I thought best to acheive this is to;
1) create Loop
2) open link
3)select all copy from webpage
4) paste special text to sheet 2
5) search for word in sheet 2, if its found then
6) rename sheet to something else (something variable as theyre may be multiple)
7)create new sheet2
next
8)if not found then
next
Im comfortable with most of that but i have no idea how to copy from a web page.
I appreciate any help or a complete different suggestion if you know of a better way to achieve this.
thanks
Basically I have a list of 500 or so links (all in column A sheet1)
what Im after is a piece of code that will open them one at a time, search the page for a specific word ("local authorit", mispelt on purpose) if the word is found then highlight the link cell any colour.
the way I thought best to acheive this is to;
1) create Loop
2) open link
3)select all copy from webpage
4) paste special text to sheet 2
5) search for word in sheet 2, if its found then
6) rename sheet to something else (something variable as theyre may be multiple)
7)create new sheet2
next
8)if not found then
next
Im comfortable with most of that but i have no idea how to copy from a web page.
I appreciate any help or a complete different suggestion if you know of a better way to achieve this.
thanks