As you can see i tried many different codes but i'm still getting "document of object iwebbrowser2 failed" error and i have no idea why please help
[/ICODE]
My HTML Code
<tr>
<td width="4%" align="left" valign="middle"></td>
<td width="96%" align="left" valign="middle"><font face="arial" size="1.5">
<input align="top" type="checkbox" name="R_CustInst" value="51">
<b>BANK2</b></font></td>
</tr>
<tr>
<td width="4%" align="left" valign="middle"></td>
<td width="96%" align="left" valign="middle"><font face="arial" size="1.5">
<input align="top" type="checkbox" name="R_CustInst" value="52">
<b>BANK1</b></font></td>
</tr>
[/CODE]
My VBA Code
[/ICODE]
My HTML Code
<tr>
<td width="4%" align="left" valign="middle"></td>
<td width="96%" align="left" valign="middle"><font face="arial" size="1.5">
<input align="top" type="checkbox" name="R_CustInst" value="51">
<b>BANK2</b></font></td>
</tr>
<tr>
<td width="4%" align="left" valign="middle"></td>
<td width="96%" align="left" valign="middle"><font face="arial" size="1.5">
<input align="top" type="checkbox" name="R_CustInst" value="52">
<b>BANK1</b></font></td>
</tr>
[/CODE]
My VBA Code
VBA Code:
Sub test()
Set sht = ThisWorkbook.Sheets("Sheet1")
Dim IE As Object
Set IE = CreateObject("InternetExplorer.Application")
IE.Visible = True
IE.Navigate "http://"
Do
If IE.ReadyState <> 4 Then
IE.Visible = True
Exit Do
Else
DoEvents
End If
Loop
'Dim chBox As Object
'
' Set chBox = IE.document.getElementsByName("R_CustInst")
'
' chBox(52).Checked = True
IE.document.querySelector("[name=R_CustInst][value='52']").Click
'IE.document.getElementsByAll("[name=R_CustInst][value=52]").FireEvent
'<input align="top" type="checkbox" name="R_CustInst" value="52">
'IE.document.all("R_CustInst")(52).Checked = True
'IE.document.getElementsByTagName("BANK1").Click
'IE.document.getElementsByValue("52")
'IE.document.getElementByAttribute("Type").Click
'IE.document.getElementById("Type").Click
'IE.document.querySelector("[name=R_CustInst][value='52']").Click
Set IE = Nothing
End Sub
[ICODE]
i'm new to this and i'm a mess been at it long and i give up Please help PLEASE!
What i want to do is => On that same site i have to tick on 4 Check box and 2 radio button to fetch the table data,than copy paste the acquired table in excel sheet but i can't get pass even a single one.
if nothing work how do i get the table data from already checked, submitted and fetched data table from open browser to Excel sheet
Can we not use "BANK1" or "BANK2" names to get the elements as they are the Unique '<b>BANK1</b>' like #input where tag is BANK1 or something. i'm not sure what am i saying but maybe?