get data from web into excel cells

[joep311]

Dear sir/madam,



I am new to Excel and have no programming experience, so please bear with me...
I am desperately looking for a solution for the following problem:



Right now I am manually using a website (http://gpx.cgtk.co.uk/) to get a list of latitude and longitude points of a certain route.
I enter a certain adress on this website as a starting point and another adress as a destination. (street, nr, city, country)
I choose the metric system and then click "go" after which the website loads the route between these 2 points.
Then I save the route as a garmin GPX file and open it again to copy the lat/long coordinates and paste these into a different excel sheet.



I want to accomplish the following:


I have an excel sheet with one cell where I can insert a starting adress and another cell where I can insert the destination adres.
A third cell contains an unique ID number. (f.e. 4321X)
Then, when I click on a macro button, the proces written above should occur automatically whereafter I should be looking at an excell
sheet (named 4321X.xls) with rows containing only the latitudes and longitudes of the route and 1 cell containing the unique ID number.


I have so far not found a way to have excel automatically put cell-data into a website and record output data from an automatically
saved file into a newly created excel sheet.


Can someone tell me whether this is even possible, and if yes, send me in the right direction?


Thank you in advance,



Joep

PS: I am using Excel 2013

 

[kumarapush123]

It is possible. Lets split the activities into small tasks.
#1 - Submitting the query with From and To Address & then click 'Go' button.
a) View page source and find the name of From, To Text Fields. (I found it as 1. "from-input", "to-input")
b) View page source and find the name of Metric Field (I found that too . it is "unit-input")
c) View page source and find name for "go" Button (it is "gobutton")
d) Wait for page to load and find for Route Title name (pls chk in page source or Inspect element)
e) Click "Save Route" Button.
f) Wait for page to load and click on "Download Garmin GFX" File.
Well, what you have to do is, write down all the names of these fields involved in this above 6 steps.

Then take the code from this reference article, which is an example that try to login to facebook from excel. You can modify this code, with your URL and Field names.

This way, you can pass From and To route addresses and get the download file.

 

[joep311]

Thank you very much for this!
I will look into this when I get home and will post the result!

Have a nice Sunday!