+ Reply to Thread
Results 1 to 2 of 2

Read multiple earth coordinates from an excel file, and draw markers in a map

Hybrid View

  1. #1
    Registered User
    Join Date
    10-10-2013
    Location
    Guadalajara
    MS-Off Ver
    Excel 2003
    Posts
    1

    Read multiple earth coordinates from an excel file, and draw markers in a map

    Hi,

    I have an excell file with a column with earth coordinates inside Spain.I want to put those markers in a map of Spain, how can I generate those markers in a map? I don't need details, but just abstract information.

    Should I create a macro maybe? Should I use google maps?

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Read multiple earth coordinates from an excel file, and draw markers in a map

    I suppose something like:
    Sub macro_1()
    Dim co_ordinate_1, co_ordinate_2, ieapp
    co_ordinate_1 = "0.12341235"
    co_ordinate_2 = "0.12453412"
    Set ieapp = CreateObject("internetexplorer.application")
    ieapp.navigate "https://maps.google.com/maps?q=" & co_ordinate_1 & "," & co_ordinate_2
    ieapp.Visible = True
    End Sub
    might work, depending on your co-ordinate system.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Skip The Read Only Prompt When I Open A File - Excel, Open it read-write instead.
    By harry_1805 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-06-2012, 02:14 AM
  2. Replies: 1
    Last Post: 01-21-2012, 07:43 AM
  3. Excel changes empty chart w/o markers to chart w/ markers
    By Dante_Blake in forum Excel General
    Replies: 1
    Last Post: 09-28-2011, 04:17 PM
  4. read value of strings from a text file and make an excel file.
    By gashforing in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-08-2009, 07:12 AM
  5. Neet to use Excel to read in multiple-sheet file
    By VMetze in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-29-2006, 03:20 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1