title: Scraping Web VBA Excel unclear
body: <p>I just started learning web scraping and I'm trying to make a code that Search for specific Data in Web page and click on search then Extract specific Data in excel sheet , I succeed to put the variable that I want to look for in the Web page but When I use the search button I receive this error <a href="https://i.stack.imgur.com/MlyEs.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/MlyEs.jpg" alt="enter image description here" /></a></p>
  <p>I donno how to do it or to correct it
  this is my code and Button code</p>
  <p>VBA Code</p>
  <pre><code>     Sub clickICC()
       Dim ie As Object
       Dim form As Variant, button As Variant
       Set ie = CreateObject(&quot;InternetExplorer.Application&quot;)
  
       myjobtyp = InputBox(&quot;Enter type of MP,MOD,DATE&quot;)
  
  
        With ie
       .Visible = True
       .navigate (&quot;http://XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX&quot;)
  
  
       While ie.ReadyState &lt;&gt; 4
      DoEvents
       Wend
  
       ie.document.getElementsbyname(&quot;searchById&quot;).Item.innertext = myjobtyp
  
  
      Set form = ie.document.getElementsbytagname(&quot;form&quot;)
  
       Set button = form(0).onsubmit
       form(0).submit
  
        Do While ie.busy: DoEvents: Loop
        Set TDelements = .documents.getElementsbytagname(&quot;td&quot;)
      r = 0
       c = 0
  
        For Each TDelements In TDelements
       sheet1.Range(&quot;A1&quot;).Offset(r, c).Value = TDelement.innertext
        r = r + 1
       Next
  
  
  
  
  
        End With
         Set ie = Nothing
  
  
        End Sub
  </code></pre>
  <p>the web button code</p>
  <p><a href="https://i.stack.imgur.com/nJuMh.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/nJuMh.jpg" alt="enter image description here" /></a></p>
  <p>Anyone have a clue about this or light me on how fixing this  ?</p>