Address spreadsheet to maps

garbology

New Member
Joined
Mar 26, 2015
Messages
18
I have a list of addresses 100ish. Is there a way to vba from Excel to map out a route to follow in Google maps, Waze, Bing maps, it any other option.
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
There are ways to highlight coordinates on a map. Routing 100 addresses is a very different thing. It is called the traveling salesman problem and is very difficult to solve.

 
Upvote 0
G-maps does allow to add points (10 I think) I didn't know If there where any options. Vba, script, anything. I'm always up to learning something new I just don't know where to start.
 
Upvote 0
Also I should add I'm not looking for any programming to figure it witch stop I should make first. My list is in order I'm just looking for something to say "hey stop here" so I don't happen to miss a stop
 
Upvote 0
Dear Sijpie
I have been successful at unloading those addresses in the past on to Google maps, like described above from that point I couldn't figure out how to make maps tell me to stop at a point while driving.
 
Upvote 0
Ok, got it. No I would not have a clue how to do that. Perhaps talk to Google
 
Upvote 0

Forum statistics

Threads
1,214,827
Messages
6,121,823
Members
449,049
Latest member
cybersurfer5000

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top