How to click button on a webpage, using inspect

[ExcelJWS]

Hi guys,


I have made a program that will put addresses into the website Distance between two addresses, cities or zipcodes


But I don't know how to get excel to Click on the "calculate distance" button. I've looked on a bunch of youtube videos (which is why I'm able to put values into the 'from' and 'to' boxes. But am still unable to get it to click the button for me). It should be the last lane of code that needs to be changed to something else.

    Dim IE As Object
    Set IE = CreateObject("InternetExplorer.Application")


    IE.navigate "http://www.mapdevelopers.com/distance_from_to.php"
    Do
    DoEvents
    Loop Until IE.readyState = READYSTATE_COMPLETE
    IE.document.all("from").Value = Addy1.Value
    IE.document.all("to").Value = Addy2.Value

The code above puts the addresses into the website
the code below is my attempt to click on the "calculate distance button"

    IE.document.all("link_button").Click

Any advice would be awesome.


Thanks,


ExcelJWS

 

[mrmmickle1]

ExcelJWS,

Welcome to the MessageBoard!

Try this line of code. I just tested it... it works for me:

IE.document.forms(1).submit

 

[Kyle123]

X posted at excelforum

 

[ExcelJWS]

ExcelJWS,

Welcome to the MessageBoard!

Try this line of code. I just tested it... it works for me:

IE.document.forms(1).submit

Hey mrmmcikle1,

Do you have any ways of discovering what code you'll need for a particular button on a website or is it trial and error?
lets say you wanted you write something to click the reply button on this forum. After using "inspect" how would you go about discovering what code you need for the button?

Thanks
EXCELJWS