Automatic Openning of Google Search Engine through VBA Code:
Option Explicit
Sub googleSearch()
Dim browser As New InternetExplorer
Dim htmldoc As HTMLDocument
Dim url As String
Dim i, j As Integer
Dim objcollection, objelement As Object
Application.ScreenUpdating = False
On Error GoTo Errorhandler
url = "http://www.google.co.in"
browser.navigate url
browser.Visible = True
MsgBox "Your data is being searched"
MsgBox "Chck1"
Set htmldoc = browser.document
Set objcollection = htmldoc.getElementsByTagName("Input")
MsgBox "Chck2"
While i < objcollection.Length
If objcollection(i).Name = "q" Then
MsgBox "Chck3"
objcollection(i).Value = Range("A2").Value
End If
MsgBox "Chck4"
i = i + 1
Wend
Set objcollection = Nothing
Set objcollection = htmldoc.getElementsByTagName("button")
MsgBox "Chck5"
While j < objcollection.Length
If objcollection(j).Type = "submit" Then
Set objelement = objcollection(j)
objelement.Click
End If
MsgBox "Chck6"
j = j + 1
Wend
Set objelement = Nothing
Set objcollection = Nothing
Set htmldoc = Nothing
Set browser = Nothing
Application.ScreenUpdating = True
Exit Sub
Errorhandler:
MsgBox "Error" & Err.Description
End Sub
Option Explicit
Sub googleSearch()
Dim browser As New InternetExplorer
Dim htmldoc As HTMLDocument
Dim url As String
Dim i, j As Integer
Dim objcollection, objelement As Object
Application.ScreenUpdating = False
On Error GoTo Errorhandler
url = "http://www.google.co.in"
browser.navigate url
browser.Visible = True
MsgBox "Your data is being searched"
MsgBox "Chck1"
Set htmldoc = browser.document
Set objcollection = htmldoc.getElementsByTagName("Input")
MsgBox "Chck2"
While i < objcollection.Length
If objcollection(i).Name = "q" Then
MsgBox "Chck3"
objcollection(i).Value = Range("A2").Value
End If
MsgBox "Chck4"
i = i + 1
Wend
Set objcollection = Nothing
Set objcollection = htmldoc.getElementsByTagName("button")
MsgBox "Chck5"
While j < objcollection.Length
If objcollection(j).Type = "submit" Then
Set objelement = objcollection(j)
objelement.Click
End If
MsgBox "Chck6"
j = j + 1
Wend
Set objelement = Nothing
Set objcollection = Nothing
Set htmldoc = Nothing
Set browser = Nothing
Application.ScreenUpdating = True
Exit Sub
Errorhandler:
MsgBox "Error" & Err.Description
End Sub
No comments:
Post a Comment