title: Using an IE browser with Visual Basic
body: <p>Struggling to find a solution to this one. 
  From Visual Basic (VBA in Excel more specifically) I'm able to call an Internet Explorer window by title using</p>
  
  <pre><code>AppActivate ("My Page Title - Windows Internet Explorer")
  </code></pre>
  
  <p>And it works great each time.</p>
  
  <p>I can open a new window and send a url to it using..</p>
  
  <pre><code>Dim ie As Object
  Set ie = New InternetExplorer
  ie.Visible = True
  ie.Navigate "http://websiteurl"
  </code></pre>
  
  <p>And that also works okay
  But it opens a new browser each time and I want it to always calls the same window. </p>
  
  <p>So can i Set <code>ie</code> to equal the same page each time. So instead of </p>
  
  <pre><code>Set ie = New InternetExplorer
  </code></pre>
  
  <p>It does something like</p>
  
  <pre><code>Set ie = ACTIVE InternetExplorer
  </code></pre>
  
  <p>(though that doesn't seem to exist).
  Is there some way of setting <code>ie</code> to be the same as <code>AppActivate ("My Page Title - Internet Explorer")</code> ?</p>
  
  <p>Thanks</p>
  
  <p>Full Code here:</p>
  
  <pre><code>Sub Find_Recordings()
  Dim MyAppID, ReturnValue
  
  AppActivate ("My Page Title - Windows Internet Explorer")
  
  SendKeys ("^a")
  Application.Wait (Now + TimeValue("0:00:01"))
  SendKeys ("^c")
  Application.Wait (Now + TimeValue("0:00:01"))
  
  AppActivate ("Microsoft Excel")
  Sheets("DataSearcher").Select
  Range("K1").Select
  ActiveSheet.PasteSpecial Format:="Text", Link:=False, DisplayAsIcon: = False
  
  Range("A1").Select
  
  Dim ie As Object
  Set ie = New InternetExplorer
  ie.Visible = True     ie.Navigate "http://wwwmyurl"
  
  Do Until ie.ReadyState = READYSTATE_COMPLETE
  Loop
  
  ie.Document.getElementById("searchdata1").Value = Range("J1")
  ie.Document.getElementById("library").Value = "RECORDINGS"
  ie.Document.searchform.Submit
  
  
  
  End Sub
  </code></pre>