I need to use excel ( or a custom written program) to generate road distance from one city to many, within Australia using google maps as the base calculator. The use of this program is for my courier company to print out customer rate sheets. We need to match the distance provided by our dispatch software which uses Google maps. The requirement for the software is to be able to export information to Excel ( 2007) to enable printing to PDF etc.
It would need to search via: Suburb./City/Street/Postcode. One to many. Selections: Fastest, shortest, avoid tolls.
If you cannot write a custom program, then Excel would be the perfect choice as we already have alot of information in Excel relating to suburbs.
You may research a program called PCMiler, which is something similar to what we need. I can email you a demo of PCMiler if needed.
Any further questions please do not hesitate to contact me.