Hello Everyone, I posted this thread yesterday but I cant seem to find it anymore under the excel questions forums. I have a slight dilemma I was hoping someone can help me with. I work for a company that does a lot of boiler work for well over 150 locations. We keep track of parking tickets accumulated by our drivers/mechanics on an excel spreadsheet, with over 30+ drivers, driving around NYC the tickets stack up quickly. I've spent the last couple of days trying to come up with a macro that would automatically navigate to PVO Search and fill in the "License Plate" field and select PASSENGER or COMMERCIAL vehicle (pre-determined by me in the macro) and hit the search button. I'm not super experienced with excel so my knowledge is somewhat limited. If anyone could be of assistance it would be greatly appreciated! Thank you and have a nice day. Here's how far I was able to get lol: Private Sub CommandButton1_Click()
Set IE = CreateObject("InternetExplorer.application")
IE.Visible = True
IE.navigate ("PVO Search" & ActiveCell)
Do
If IE.readyState = 4 Then
IE.Visible = False
Exit Do
Else
DoEvents
End If
Loop
IE.Document.Forms(0).all("Plate Number").Value = "NumberHere"
IE.Document.Forms(0).submit
End Sub
Set IE = CreateObject("InternetExplorer.application")
IE.Visible = True
IE.navigate ("PVO Search" & ActiveCell)
Do
If IE.readyState = 4 Then
IE.Visible = False
Exit Do
Else
DoEvents
End If
Loop
IE.Document.Forms(0).all("Plate Number").Value = "NumberHere"
IE.Document.Forms(0).submit
End Sub