getting info from excell and manipulating it on the net
2 posts
• Page 1 of 1
getting info from excell and manipulating it on the net
At work we need to find distances between zip codes to find installers that are close to the work sites. However this is a real tedious task do it long hand by plugging in the installer's zip and the site zip into mapquest or some other online program to find distances between the locations. I was wondering if there was anyway to write a short script that would automate this process, so all we would have to do is plug in the site zip and the program would extract the site zip and go down the list and compare it with the installers zip and then return the distance? any ideas?
thnaks
Re: getting info from excell and manipulating it on the net
me are confuzzled.isus wrote:At work we need to find distances between zip codes to find installers that are close to the work sites. However this is a real tedious task do it long hand by plugging in the installer's zip and the site zip into mapquest or some other online program to find distances between the locations. I was wondering if there was anyway to write a short script that would automate this process, so all we would have to do is plug in the site zip and the program would extract the site zip and go down the list and compare it with the installers zip and then return the distance? any ideas?
thnaks
- toxic chicken
- Posts: 196
- Joined: Thu Apr 20, 2006 9:18 am
- Location: nowhere, washington.
2 posts
• Page 1 of 1
Return to HTML, CSS, and Scripts
Who is online
Users browsing this forum: No registered users and 5 guests