Microsoft Excel- Plotting Lines onto Google Maps (Macro)

Just an FYI-I am a first time Macro user, but I am otherwise well versed in Excel logic and formula use.

I am trying to create a Macro that plots lines onto Google Maps based on the following:

Customer A:

Coordinates of ship from location

Coordinates of ship to location

R (2 for destination, 1 for supplier)
Customer B:

Coordinates of ship from location

Coordinates of ship to location

R (2 for destination, 1 for supplier)

And so on, and so on. This does not need to be exact, but it is an approximation to show what the most cost effective routes will be.
I have a coworker that had a macro that did this, so I know it is possible. However, he says it is not very user friendly, so I will not have access to it. He says all he uses is Google Maps and Excel. Any tips you have for creating this macro would be highly appreciated! I am open to purchasing add-ons under $100, if it will help.