Goolge Maps Data

buttonhole

New Member
Joined
Apr 19, 2019
Messages
2
Hello there,

This might be a really dumb question, if it is, just tell me it is!

As part of my job, I have to get the time and distance between two post codes and with over 200 to do, it's bit of laborious process!

I used to literally copy and paste every post code into Google, I've improved on this slightly with concatenate... i.e..



So I've gone from copying and pasting two post codes, to copy and pasting one web address (yay!)

Is there ANY way I could make this process more automated? I'm a basic macro user, I've seen stuff about google about APIs which go over my head... there are probably people out there who could make it fantastic but charge me money for. I was just hopeful there would be something I could do to make this processes easier?

...or is this something I should pay 'professionals' to do?

Thank you!
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,466
Office Version
365
Platform
Windows
Does it need to be Google?

If it does then you would need to sign up for an API key to do this.
 

buttonhole

New Member
Joined
Apr 19, 2019
Messages
2
No, it doesn't have to be Google. Any similar site that could give mileage and the time it takes to get from post code A to post code B would be fab.
 

Watch MrExcel Video

Forum statistics

Threads
1,089,938
Messages
5,411,379
Members
403,363
Latest member
gooduser

This Week's Hot Topics

Top