HI,
I've been working as programmer for years and very familiar with both VBA and Google Map API.
My proposed workflow is simple for user with two step:
1/ process the raw data
- User click on a button to run a macro, e.g getRawData
- the macro display a open file dialog for user to select the raw data file ([login to view URL])
- it clear the exiting or create a new destination worksheet and populate the according to requirements: name, pickup address, destination address, time etc. and a route information to display in the map.
2/ Display route for any row of the above mentioned worksheet:
- select any row of the destination worksheet
- click on the button: the route will be displayed on browser of user choice (chrome, firefox or ie, depend on the user's system)
I can provide working file for MS office 2010 (Windows) and MS office 2011 (Mac OSX)
Best regards,
Cuong NH