I need to scrape information from an open ASP page and plug it into a VB6 application. Can someone tell me how to refer to the currently open document in IE? There is lots of help to open a new URL, but I find nothing that relates to a web page currently open. Your help is appreciated.

'requires to add a reference to "Microsoft Internet Controls" -%systemroot%/system32/shdocvw.dll
Private Sub Form_Load()
    Dim IEWindows As SHDocVw.ShellWindows
    Dim IE As SHDocVw.InternetExplorer
    'Get a collection of all the running explorer and iexplorer windows
    Set IEWindows = New SHDocVw.ShellWindows

    For Each IE In IEWindows
        If IE.FullName = "C:\Program Files\Internet Explorer\iexplore.exe" Then 'if it's a iexplorer window
            Debug.Print IE.LocationURL 'will show the text in the address bar of the IE window
            Debug.Print IE.LocationName 'will show the text in the title bar of the IE window
            Debug.Print IE.Document.All.tags("td").length 'returns the number of <td> tags in the IE document
            'returns the text content of the first cell of first table in the webpage
            'use .innerHTML will return the html content of the first cell of the first table in the webpage
            Debug.Print IE.Document.All.tags("table")(0).cells(0).innerTex t
        End If
    Next
End Sub