>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
....