+ Reply to Thread
Results 1 to 7 of 7

Incorporating Google Map inside spreadsheet having Two locations to show locations

  1. #1
    Registered User
    Join Date
    06-10-2015
    Location
    Mumbai, India
    MS-Off Ver
    MS Office 2010
    Posts
    4

    Incorporating Google Map inside spreadsheet having Two locations to show locations

    Hey all,

    Can you guys please help me with how can i incorporate a Google Map inside a worksheet

    I have two options to select Start & End Locations in the worksheet. However, I want google maps to be shown as a window inside the sheet and catch the locations that I entered in the cells.

    I have tried using incorporating Microsoft Web Browser and then write a VBA code to get the google map. But Excel doesnt allow me to add Microsoft Web Browser "Cannot insert Object" is the error i get. I have researched a bit and found that Microsoft has disabled this object due to security issues.

    Can you guys please help me with a solution to how I can insert Google Maps in excel sheet that shows the locations that i enter in a cell

    I have used Bing Maps App from Microsoft Excel but it doesn't give exact locations and is the worst app i have seen in many years

    Thanks in Advance

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,239

    Re: Incorporating Google Map inside spreadsheet having Two locations to show locations

    Which version of office are you using? I thought the web browser was available on sheets in 2010?

  3. #3
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,239

    Re: Incorporating Google Map inside spreadsheet having Two locations to show locations

    You could always put it on a userform

  4. #4
    Registered User
    Join Date
    06-10-2015
    Location
    Mumbai, India
    MS-Off Ver
    MS Office 2010
    Posts
    4

    Re: Incorporating Google Map inside spreadsheet having Two locations to show locations

    I am using 2013 and i have tested in 2010 as well.

    Surprisingly it was working in 2007, but when I go to create a Active Command button after creating the Web browser. Excel doesn't allow me to insert a Command button and gives the error "Cannot insert Object". I want an alternate solution to this instead of using Web Browser

  5. #5
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,239

    Re: Incorporating Google Map inside spreadsheet having Two locations to show locations

    There isn't, you need to put it in a userform

  6. #6
    Registered User
    Join Date
    06-10-2015
    Location
    Mumbai, India
    MS-Off Ver
    MS Office 2010
    Posts
    4

    Re: Incorporating Google Map inside spreadsheet having Two locations to show locations

    Hi, Kyle
    Thanks for your response. I used a Userform to do this and succeded in getting the web browser.
    However, I am facing a different issue now. When i did the above and created a command button to get the map.
    I receive an message saying "You seem to be using an unsupported Browser".

    Currently I have all the updated browsers on my PC. IE 11 & Chrome latest version updated.

    I trued changing the default browsers from IE to Chrome and back from Chrome to IE 11. But I find no result. Can you please help me how can i get the map dispalyed



    Thanks in Advance

    Phani

  7. #7
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,239

    Re: Incorporating Google Map inside spreadsheet having Two locations to show locations

    It's because the web browser uses a really old version of IE, it doesn't matter what your default browser is. Have you tried something like Bing Maps or Open Street Map to see if you have any better luck?

+ 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. Replies: 1
    Last Post: 07-05-2014, 04:07 PM
  2. spreadsheet to analyze raw material locations
    By jim62 in forum Excel General
    Replies: 1
    Last Post: 06-24-2014, 03:22 AM
  3. [SOLVED] Backup spreadsheet in several locations!?
    By domgilberto in forum Excel General
    Replies: 3
    Last Post: 05-13-2014, 03:40 PM
  4. [SOLVED] show unique locations or account # by month
    By jw01 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-02-2013, 02:55 PM
  5. Replies: 2
    Last Post: 07-09-2012, 12:28 PM

Tags for this Thread

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