title: Excel VBA to auto search specific website
body: <p>I'm trying to make an Excel macro that opens up IE&lt; then goes to www.selectleaders.com, then enters a location in the location field (ideally one pulled from a cell in the Excel, not hard-coded in the macro), then activates the search field.</p>
  
  <p>So far what I have is as follows, but I'm at a loss as to what to insert for the ??? to get it to work.  </p>
  
  <p>Any suggestions or tips?</p>
  
  <pre><code>Sub SelectLeadersSignIn()
  Dim ie As Object
  Dim location
  Dim button
  Set ie = CreateObject("InternetExplorer.Application")
  With ie
      .Visible = True
      .Navigate ("https://www.selectleaders.com")
      While ie.ReadyState &lt;&gt; 4
          DoEvents
      Wend
      Set location = .document.getElementById("?????")
      Set button = .document.getElementById("?????")
      button.Click
      While ie.ReadyState &lt;&gt; 4
          DoEvents
      Wend
  End With
  Set ie = Nothing
  
  End Sub
  </code></pre>