Excel VB Mapquest

[luths6]

Hello,

I am very new to VB and excel. I am currently in a internship and am doing some distance calculations for shipping via road. I have a data set somewhere near 700 which if done by hand could be very time consuming. I have this current function that manages to open a instance of Internet explorer and calculate with Mapquest the driving distance between two points. The issue arises with pulling the distance from mapquest into its excel cell. I was wondering if anyone would take a look at it with me. I'm not sure where to go from here. Any help would be great. Thanks!

[luths6]

Actually.. I thought I had it figured out, but it ended up not working. I think the main issue is that Mapquest changed up their page. The original code I was working with was created for a much older Mapquest.

Please Login or Register  to view this content.

[Leith Ross]

Hello luths6,

Welcome to the Forum!

It would help to see the original macro. Can you post it?

To Attach a File:

1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[luths6]

Thx. I posted an attachment.

[luths6]

I solved the problem. Mapquest updated to a new page for driving directions. The html changed enough to throw off the function I was working with. This function will pull driving time and distance from mapquest into your excel file. I needed to change the url being accessed to the classic mapquest.

Please Login or Register  to view this content.