[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

How to use a Macro in Excel to extract information from Google Maps

Posted on 2014-12-17
4
Medium Priority
?
152 Views
Last Modified: 2015-01-15
Hi,

I am trying to use visual basic Macro or something like it to extract information using excel based on certain keywords such coordinate to get information from google maps.  Please help.

Thanks,

Mareeka
0
Comment
Question by:mareeka
3 Comments
 
LVL 17

Accepted Solution

by:
vb_elmar earned 2000 total points
ID: 40506278
I added a XLS sample with a macro.
3.xls
0
 

Author Comment

by:mareeka
ID: 40506905
Thanks,

I would like to have distance in miles between several addresses.  As shown in the sample excel file, I would like to enter a location in a spreadsheet and distance from the previous location is automatically calculated .  So that I can calculate the total distance until returned to original location.  

Thanks again,

Mareeka
sample.xlsx
0
 
LVL 51

Expert Comment

by:Martin Liss
ID: 40550854
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

590 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question