>I want to get the field of HTML into the database
>
>but i am unable to understand it proparly , i am using a script which checks the active url in the current IE window and out of that i can praise the one i want to my database.
>
>after a search i am able to do the following and got the active url from the internet explorer using the below script
>
>Dim shellWins As SHDocVw.ShellWindows
> Dim explorer As SHDocVw.InternetExplorer
> shellWins = New SHDocVw.ShellWindows
>
> For Each explorer In shellWins
> Debug.Print(explorer.LocationName)
> Debug.Print(explorer.LocationURL)
> Me.Label1.Text = explorer.LocationName
> Me.Label2.Text = explorer.LocationURL
> MsgBox(Me.Label1.Text & "-" & Me.Label2.Text)
> If Me.Label1.Text = "Services Network" Then
> Me.Label1.Text = explorer.LocationName
> Me.Label2.Text = explorer.LocationURL
> MsgBox(Me.Label1.Text & "-" & Me.Label2.Text)
>
> ' Now here i want to extract the url source code and then search for various content in that
> just like parsing the HTML
>
>
> End If
> Next
>
> shellWins = Nothing
> explorer = Nothing
>
>kindly if any example available for getting content from HTML

See if you can follow this example:

  For Each explorer In shellWins
           For ia = 0 To explorer.Document.All.length - 1
                Debug.Print(explorer.Document.All.Item(ia).NodeName)
                if not IsDBNull(explorer.Document.All.Item(ia).NodeValue)
                        Debug.Print(explorer.Document.All.Item(ia).NodeValue)
                end if
            Next
....