title: Where to find VBA functions for working with internet explorer
body: <p>I am working on a VBA function to go to a webpage, find a single HTML element, and display its contents. Here is what I have so far.</p>
  
  <pre><code>Function WebTableToSheet(webpage As String, tag As String, count As Integer) As String
  
  
    'Tested using IE7,  Excel 2000 SP1, and Windows XP
    Dim objIE As Object
    Dim varTables, varTable, document
    Dim allTags, tags
    Dim varRows, varRow
    Dim varCells, varCell
    Dim lngRow As Long, lngColumn As Long
    Dim strBuffer As String
  
    Set objIE = CreateObject("InternetExplorer.Application")
  
   'Setup
    With objIE
      .AddressBar = False
      .StatusBar = False
      .MenuBar = False
      .Toolbar = 0
      .Visible = True
      .Navigate webpage
    End With
  
    'Load webpage
    While objIE.Busy
    Wend
    While objIE.document.ReadyState &lt;&gt; "complete"
    Wend
  
  
    varTable = objIE.document.All
  
    allTags = objIE.document.All.tags(tag)
  
    WebTableToSheet = allTags.Item(count)
  
    Debug.Print "Testing function"
  
  
  
  
  Cleanup:
      Set varCell = Nothing: Set varCells = Nothing
      Set varRow = Nothing: Set varRows = Nothing
      Set varTable = Nothing: Set varTables = Nothing
      objIE.Quit
      Set objIE = Nothing
  End Function
  </code></pre>
  
  <p>I am able to open InternetExplorer, got to the webpage specified in the function, but when I try searching for a specific tag, it seems to fail. I have had trouble searching for Microsoft VBA Internet Explorer documentation and knew what variables and methods are available for this task?</p>