Click to See Complete Forum and Search --> : Importing data from a web page
Garrin_B
Oct 13th, 2000, 04:32 PM
How would I go about importing data from a web page, for instance a table, into a text field. This is assuming that the web page is always in the same format. What about if there are multiple tables on the page, how could I pull data from different cells from different tables? Thanks.
Dim
Oct 13th, 2000, 05:11 PM
Well what you could do is take the code from the page and parse it to specified places and place the parsed text into specific text boxes.
Something like
Text1.Text = Inet1.OpenURL("http://www.somesite.com/index.asp", icString)
Dim int_Pos As Integer
Dim int_X As Integer
For int_X = 1 To CInt(Text2.Text)
int_Pos = int_Pos + 1
int_Pos = InStr(int_Pos, Text1.Text, Text3.Text)
If int_Pos = 0 Then Exit Sub
Text4 = Mid(Text1.Text, int_Pos + Len(Text3.Text), 12)
Next
'Play around with this code and you'll realize what
'you have to do to achieve what you want.
Gl,
D!m
vbforums.com
Copyright Internet.com Inc., All Rights Reserved.