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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.