title: Find form ID on a website and input value using VBA
body: <p>I would require a bit of help finding a form id on a public website (<a href="http://www.medicines.ie/" rel="nofollow noreferrer">http://www.medicines.ie/</a>). They updated the site and the previous id no longer works since now there is no Id to be found. What I am trying to do is open this site with VBA, input the value from a specific cell in excel to a form (textbox) on this website and press the search button. I am using the code below:</p>
  
  <pre><code>Sub Medicinesie()
  Dim IE As Object
  Set IE = CreateObject("INTERNETEXPLORER.APPLICATION")
  IE.navigate "http://www.medicines.ie/"
  IE.Visible = True
  
  Do
  DoEvents
  Loop Until IE.ReadyState = READYSTATE_COMPLETE
  
      IE.Document.getElementById("input").Value = Range("spc")  '&lt;---- spc is the name of the cell I am referencing 
      IE.Document.forms(0).submit
  
  Do
  DoEvents
  Loop Until IE.ReadyState = READYSTATE_COMPLETE
  
  End Sub
  </code></pre>