Hi guys,
I've been searching relentlessly for a solution to my problem but with no luck, so I am turning to you for advice.
I have around 7000 football matches, in excel, and want to find the distance between the stadiums of the two football teams for each match. I have a website where I can input both teams' names and search for the distance between their stadiums. I would like to set up a macro that uses the football team names from column B and C as search criteria, enters them on the website, clicks search and then extracts one element ... the driving distance in miles.
I cannot for the life of me find anything remotely close to this online that would act as a template for me to work with and develop this macro. Perhaps there is a name for this which I don't know so I am searching for the wrong thing. Could you please let me know if you are familiar with the approach I am trying to take, or whether there is a better way to go about obtaining the distance information? If a thread on this matter already exists then please please refer me to it because I haven't found it yet =(
EDIT:
URL for obtaining distance info: http://www.sportmapworld.com/distanc...st-ham-united/
The "distance from" and "distance to" fields would need to be updated with the info in columns B and C of the excel file, and the "driving distance" (in miles) is the element I would like to extract.
Bookmarks