Code:
Sub Scrambledata()
Dim ie As Object, objInputs As Object
Set ie = CreateObject("InternetExplorer.Application")
ie.Visible = True
ie.Navigate "http://www.scramble.nl/military-database/usaf"
Do While ie.ReadyState <> 4: DoEvents: Loop
ie.Document.getElementById("serial").Value = Sheets("Scramble").Range("A2").Value
Set objInputs = ie.Document.getElementsByTagName("input")
For Each ele In objInputs
If ele.Name Like "sbm" Then
ele.Click
Exit For
End If
Next
End Sub
I have a value in cell A2 = 03-3114, code above is searching website for that input and returns with results in a table
I am trying to scrape that data back into excel cell, I tried few different ways but so far I have not found working solution
Search for serial 03-3114 returns type = C-17A (third field in the table)
I'd like to import that value into my table in to cell B2,
I was able to find xPath using Firefox Firebug but I dont know what to do next
/html/body/div[1]/div/div[2]/div/div[2]/div[5]/div[2]/div[1]/table/tbody/tr[3]/td[3]/span
any help/hint is appreciated.