Hi all,
I am using VBA to navigate through the website - this is the coding
Sub newportcarreg()
Dim lot As String
Set objie = CreateObject("internetExplorer.application")
With objie
.Visible = False
.navigate (not able to post the link but the code to the button is at the bottom - also you could type in newport auction in gogle and you will get the link)
Do While .busy Or _
.readystate <> 4
DoEvents
Loop
Do Until ActiveCell.Value = ""
lot = ActiveCell.Value
Sheet1.Range("a1").End(xlDown).Offset(1, 0).Value = .document.getElementById(lot).innertext
ActiveCell.Offset(1, 0).Select
Loop
End With
'
End Sub
With this code I am able to go to the website and pull the information from the 1st page. But I am unable to navigate to page 2 and pull the data from page 2 because the button on the website is not exactly a button that I can use a click command in VBA. Its a href tag with java scritp - <a href="javascript:__doPostBack('GridView1','Page$2')">2</a>
Can any1 help me and let me how I can navigate to page 2 through VBA?
Thank you
Harshil
