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

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
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,516
Messages
6,119,979
Members
448,934
Latest member
audette89

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