Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Read data from a web page

Status
Not open for further replies.

chogben

Programmer
Apr 5, 2002
73
GB
I'm trying to create a recordset based on a table stored on the companny's intranet. Navigating to the page is no problem, it's reading the data. Any ideas?
 
If you have data arranged in table on the page then you can navigate trough the lines whith code like this:
If WebBrowser1.ReadyState = READYSTATE_COMPLETE Then
With WebBrowser1.Document.Forms(0)
For i = 0 To .elements.length - 1
'code for row
Next i
End with
End If
This mean that you have to put a webbrowser control on a form and set its url to company's intranet page.
To check for id of the element in the table use :
.elements(i).Id
or to set value in the input box :
elements(i).Value = yourValue

Don't kill a pig for one kilogram meat!
Boban.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top