Excel VB Mapquest

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!

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.

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.