+ Reply to Thread
Results 1 to 7 of 7

WebBrowser Control Alternative

  1. #1
    Forum Contributor
    Join Date
    03-08-2018
    Location
    Denmark
    MS-Off Ver
    2016 for Windows
    Posts
    413

    WebBrowser Control Alternative

    Is there any alternative to the Webbrowser Control as it does not work with Google maps?

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,972

    Re: WebBrowser Control Alternative

    Can you be more specific?

    Depending on your need following may work:
    1. API call using MSXML2.ServerXmlhttp
    2. You can still use IE on google maps. Though you'd need to be creative in ways to parse/read data.
    3. Use Selenium wrapper to pilot Chrome.

    etc.
    "Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something."
    ― Robert A. Heinlein

  3. #3
    Forum Contributor
    Join Date
    03-08-2018
    Location
    Denmark
    MS-Off Ver
    2016 for Windows
    Posts
    413

    Re: WebBrowser Control Alternative

    CK76

    I do appreciate your answer, I just don't understand it :-)
    I am not a advanced user of VBA, but I can make a application with a userform with a Webbrowser control.
    My intension was to get the destination directions from Google Maps on a modeless userform.

    But what I can read from others with my problem is that the webbrowser control has not been updated since IE 7 and therefor gives an error when trying to run Google Maps on it.
    I can google Brownies and chocolate chip cookies, and that is great, but I also wanted go get driving directions :-)
    I have tryied to update the registry with no look.
    My application will be used by my colleagues so I need a solution where I doen't try to change there registry for HKEY_CURRENT_USER and HKEY_LOCAL_MACHINE.

  4. #4
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,972

    Re: WebBrowser Control Alternative

    Then use Google API(s).
    Distance-Matrix or Directions API.
    https://developers.google.com/maps/d...e-matrix/intro

    Note that this requires API Key, and you should read API usage & billing document. There was change to the model sometime last year, if I recall...

    It's been a while since I coded for Google API and a lot has changed since (last time I did it was back in 2016/17). Try checking link below.
    https://pulseinfomatics.com/new-use-...sses-in-excel/

  5. #5
    Forum Contributor
    Join Date
    03-08-2018
    Location
    Denmark
    MS-Off Ver
    2016 for Windows
    Posts
    413

    Re: WebBrowser Control Alternative

    I do use Google API(s). and have a API KEY.
    I have made a application with The distance-Matrix.

    What I want now is to make a application for Directions and that is no problem if I just open it in a Browser All Examples on You Tube show.
    I want to open it on a userform with a Webbrowser.

  6. #6
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,972

    Re: WebBrowser Control Alternative

    UserForm with webbrowser isn't possible as far as I know, since it's controls are not updated as you mentioned.

    I'm not sure what exactly you are trying to do... if you need Directions. Just use Directions API. Basically same concept as Distance & Matrix API, just different endpoint and parameters supplied.

    If you want visual element, then why not just use Selenium Wrapper to control Chrome?

  7. #7
    Forum Contributor
    Join Date
    03-08-2018
    Location
    Denmark
    MS-Off Ver
    2016 for Windows
    Posts
    413

    Re: WebBrowser Control Alternative

    just looked up Selenium Wrapper and will have a look at it.

    Thanks

+ 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. How to get the frameid or name using webbrowser control
    By Amitkkar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-17-2017, 09:49 AM
  2. Display other controls ON TOP of the webbrowser control
    By EchoPassenger in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-06-2017, 06:13 PM
  3. [SOLVED] Rendering CSS3 in the WebBrowser Control
    By EchoPassenger in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-30-2015, 06:26 PM
  4. Printing a WebBrowser Control
    By jwillis07 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-31-2013, 06:01 AM
  5. Using WebBrowser Control
    By MikeLanglois in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-10-2013, 01:38 PM
  6. Removing border around Webbrowser Control
    By ge0rge in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-07-2009, 09:25 AM
  7. [SOLVED] Problem with webbrowser control
    By Mike NG in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-14-2005, 07:06 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