Hi
Firstly, I have been using vb.net for only a few hours, I have a decent background in vba so trying to 'step up'
I am trying to parse a webpage, a bit of google got me a working MSHTML example but I'm having a bit of trouble in getting at stuff
In english what I am trying to do is to loop through all the tables in my objMSHTML3 object, find one called "tCouponRadios" and then loop through each row in it and each cell within that (to get at the text of each cell)
so far I have
col1 = objMSHTML3.All.tags("Table")
For iLoop1 = 0 To col1.length
If col1.item(iLoop1).id = "tCouponRadios" Then
Debug.WriteLine(col1.item(iLoop1).id)
For Each HTMLTableRow In col1.item(iLoop1)
Debug.WriteLine(HTMLTableRow.class)
Next
End If
Next iLoop1
I can find the table (yay) but then trying to split that table into rows and then cells is where I'm getting stuck
I've tried searching and no joy but I'm not exactly sure what to search for so appologies if this has been answered somewhere else
can anyone point me in the right direction?
Many thanks, Gary
Firstly, I have been using vb.net for only a few hours, I have a decent background in vba so trying to 'step up'
I am trying to parse a webpage, a bit of google got me a working MSHTML example but I'm having a bit of trouble in getting at stuff
In english what I am trying to do is to loop through all the tables in my objMSHTML3 object, find one called "tCouponRadios" and then loop through each row in it and each cell within that (to get at the text of each cell)
so far I have
col1 = objMSHTML3.All.tags("Table")
For iLoop1 = 0 To col1.length
If col1.item(iLoop1).id = "tCouponRadios" Then
Debug.WriteLine(col1.item(iLoop1).id)
For Each HTMLTableRow In col1.item(iLoop1)
Debug.WriteLine(HTMLTableRow.class)
Next
End If
Next iLoop1
I can find the table (yay) but then trying to split that table into rows and then cells is where I'm getting stuck
I've tried searching and no joy but I'm not exactly sure what to search for so appologies if this has been answered somewhere else
can anyone point me in the right direction?
Many thanks, Gary