VBA to click button to login to website

nightracer

Board Regular
Joined
May 17, 2004
Messages
137
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
 
Last edited:

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Watch MrExcel Video

Forum statistics

Threads
1,102,542
Messages
5,487,473
Members
407,603
Latest member
jortronm

This Week's Hot Topics

Top