Daman2971985
New Member
- Joined
- Mar 1, 2011
- Messages
- 1
Weird one for my first post on this forum but here goes!<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
<o> </o>
I have a friend who works as a travelling support worker (ie she drives to a number of different disabled people’s homes every day) come the end of the month she has to work out a mileage claim form…. She currently does this by sitting on google maps looking up the various driving miles between each appointment and manually inputting them into a spreadsheet. As you can imagine this is a very slow and tedious task to do each and every month!<o></o>
<o> </o>
What I would like to do is create a VBA program into which she can just type a long list of postcodes and the various driving miles just pop out at the end.<o></o>
<o> </o>
The VBA side of it I can handle, theres nothing complicated there (just a few loops and data collection) what I haven’t found a way of doing is getting the actual driving miles! I was hoping someone would have a suggestion?<o></o>
<o> </o>
I did wonder at trying to retrieve the distances directly from the web using the data import functions…. That would seem like the most sensible way, unfortunately the web addresses for the direction sites either don’t seem to directly contain the postcodes or the output data isn’t contained somewhere excel can retrieve it from! I just don’t know where to start!<o></o>
<o> </o>
Any good places to start/look would be brilliant! 3<SUP>rd</SUP> party software maybe?<o></o>
<o> </o>
Thanks in advance<o></o>
Luke
fficeffice" /><o></o><o
> </o>I have a friend who works as a travelling support worker (ie she drives to a number of different disabled people’s homes every day) come the end of the month she has to work out a mileage claim form…. She currently does this by sitting on google maps looking up the various driving miles between each appointment and manually inputting them into a spreadsheet. As you can imagine this is a very slow and tedious task to do each and every month!<o
></o><o
> </o>What I would like to do is create a VBA program into which she can just type a long list of postcodes and the various driving miles just pop out at the end.<o
></o><o
> </o>The VBA side of it I can handle, theres nothing complicated there (just a few loops and data collection) what I haven’t found a way of doing is getting the actual driving miles! I was hoping someone would have a suggestion?<o
></o><o
> </o>I did wonder at trying to retrieve the distances directly from the web using the data import functions…. That would seem like the most sensible way, unfortunately the web addresses for the direction sites either don’t seem to directly contain the postcodes or the output data isn’t contained somewhere excel can retrieve it from! I just don’t know where to start!<o
></o><o
> </o>Any good places to start/look would be brilliant! 3<SUP>rd</SUP> party software maybe?<o
></o><o
> </o>Thanks in advance<o
></o>Luke
