nightracer
Board Regular
- Joined
- May 17, 2004
- Messages
- 147
- Office Version
- 365
Hi
I'm trying to automate a log in for a website to put live pricing into excel.
I can get it to fill in the username and password but the coding to click the 'Go' button doesn't work.
The script for the buttin under 'inspect element' is:
<input class="weebutton" type="submit" value="GO!" />
input class="weebutton" type="submit" value="GO!"
I have:
Dim ele As MSHTML.IHTMLElement
Dim eles As MSHTML.IHTMLElementCollection
Set eles = idoc.getElementsByTagName("input")
For Each ele In eles
If ele.Value = "GO!" Then
ele.Click
Else
End If
Next ele
End Sub
Can anyone help?
Many thanks
N
I'm trying to automate a log in for a website to put live pricing into excel.
I can get it to fill in the username and password but the coding to click the 'Go' button doesn't work.
The script for the buttin under 'inspect element' is:
<input class="weebutton" type="submit" value="GO!" />
input class="weebutton" type="submit" value="GO!"
I have:
Dim ele As MSHTML.IHTMLElement
Dim eles As MSHTML.IHTMLElementCollection
Set eles = idoc.getElementsByTagName("input")
For Each ele In eles
If ele.Value = "GO!" Then
ele.Click
Else
End If
Next ele
End Sub
Can anyone help?
Many thanks
N
Last edited: