How do I get the value of radio button

shoaibkadri

New Member
Joined
Jul 13, 2011
Messages
2
Hello all,I am struck in my code....
The scenerio is like this there are multiple tables in my web page. Each table has 7 column the 2 column is a check box while the 3 column is a radio button.Now i need the value of one such table on excel sheet.
I have done till here but the problem is i am unable to pull the value of the radio button n checkbox. :(
Is there anyway i can traverse in the html within the table :S
the code to pull table data follows:


Set mDocument = ie.Document
For Each element In mDocument.all 'search all the elements of the web page

If InStr(1, element.tagName, "TABLE") > 0 Then
Set tbl = element
If tbl.ID = "xyz" Then
For x = 0 To tbl.Rows.Length - 1 ' Cycle through rows
Set tr = tbl.Rows(x)
For y = 0 To tr.Cells.Length - 1 'Cycle through cells
Set tc = tr.Cells(y)
Sheets("Sheet2").Cells(k, y + 1).Value = tc.innerText
Next y
k = k + 1
Next x
End If
End If
Next

Please help
 
Last edited:

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
Hey BrandonWLH I did not get you :S
I am not sure if these are activex control the data being pulled is on a webpage(HTML content)
I have no acess to the coding other than the view source...
 
Upvote 0

Forum statistics

Threads
1,224,609
Messages
6,179,876
Members
452,949
Latest member
Dupuhini

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top