Find words on website using macro?? can this be done??

traxx

New Member
Joined
Nov 25, 2009
Messages
3
i have this code that calls/loads hyperlink on a browser using macro...now, i want to find words on the site using macro..can this be done??:(:confused:

Goal: to know if the words listed in an excel sheet present on the website..

Please help..Thanks...:biggrin:
 

traxx

New Member
Joined
Nov 25, 2009
Messages
3
here's the code im telling you about...

Sub View()
Dim i As Integer
Sheets("Sheet1").Range("e1").Select

For i = 1 To 2

On Error GoTo ErrorHandler
ActiveCell.Offset(1, 0).Select
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
ActiveCell.EntireRow.Interior.ColorIndex = 6
Application.Wait Now + TimeValue("0:0:3")
Next i

ErrorHandler:
ActiveCell.Interior.ColorIndex = 6
Resume Next

End Sub

that code opens the link listed in an excel for several seconds then opens the next one and so on..

now, if its possible, i want to find certain text on the site, color the cell green if the word is on the site while red when the word is not...

thanks in advance guys...
 

Forum statistics

Threads
1,082,478
Messages
5,365,786
Members
400,850
Latest member
Raj_Jpr

Some videos you may like

This Week's Hot Topics

Top