Input distanct from a map into excel

C

CAM

Hello,

I have a user who goes into the Internet using Bing map or Google map to get
sales person driving miles from point A to point B then input the mileage in
Excel 2007 expense report for reimbursement. The problem is there are many
salespersons and each individual sales person travels to many different
places. This is very time comsuming. What I like to is have the user input
in a cell(s) FROM - The address, City, State, Zip in another cell(s) the
TO - Address, City, State, Zip. and in another cell will display the
distance. I am justing wandering if there any add-in or a way to do this.
Any help, tips will be appreciated. Thank you in advance.

Regards
 
C

CAM

Thanks Joel I did some modification and woks great. Again I appreciate your
help.

Regards,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top