"classic" google maps not working in vba webbrowser control

Posted on 2013-10-20
Medium Priority
Last Modified: 2013-10-29
Since Google recently changed their map interface, users were given the option of reverting to the "Classic" interface.  This works fine in IE10 but when accessing Google Maps from within the web browser control (presumably the same engine code), the interface does not respond (links don't work, map can't be dragged, pegman grayed out).  We are using the WB control in several Excel 2010 spreadsheets (Windows 7 pro and 8) to display locations on Google Maps.  This was working fine in all cases until a few days ago when the "classic" view became unresponsive in the WB control.  This problem affects any application which  navigates the WB control to the Google Maps url (all other WB functionality works fine).  We have also noted, that on older XP boxes running IE6 (for reasons of legacy application compatibility), the the GM interface continues to work fine.   I'm guessing that there is some sort of security setting that is preventing newer versions (10) of IE-based WB control from working?   Any ideas?

note: We have also found that the WB control on an XP box running IE8 also works fine.  Update: W7Pro running IE9 also works ok
Question by:donald_musick
  • 3
  • 2
LVL 21
ID: 39588958
I am experiencing the same thing with Access 21010 on Windows 7.  I can not properly view any website that uses client side JAVA script.


1) Web page saved locally to hard drive into %temp% folder

2) add the following line to the beginning of the file

<!-- saved from url=(0014)about:internet -->

3) Disabled protected mode

4) Changed Me.WebBrowser0.ControlSource to point to local file saved in %tep% directory

Me.WebBrowser0.ControlSource = "file://%temp%/foo.html"

Mark of the Web
Enhanced Protected Mode and Local Files

We have also noted, that on older XP boxes running IE6 (for reasons of legacy application compatibility)
Windows 7 Pro includes XP Mode at no additional cost just for running these legacy apps.  I have converted several XP machine's hard drives to to Virtual Machines. This allows me to  run the XP instance inside Windows 7/8 without having to reinstall any of the old software. Very slick!

Author Comment

ID: 39591010
Unfortunately, saving the Google webpage locally and re-accessing is not an option.  This Excel app with the embedded wb works fine when accessing other sites, just not Google Maps.  Furthermore, switching to the "new" google map interface works also (map can be dragged, zoomed etc), but this interface no longer supports simultaneous viewing of map and streetview which is necessary for our app.  Switching back to "classic" GM once again causes the interface to become non responsive (where the wb control is wrapping IE10).

Accepted Solution

donald_musick earned 0 total points
ID: 39597815
Turns out that the webbrowser control embedded in an Excel app on a W7 IE10 box works fine if you force Excel to emulate IE9 by introducing an emulation entry in the entry.  Once this entry is made, all works fine again.

See the following links for a complete explanation:


LVL 21
ID: 39599011
Thanks for sharing the solution!   It is much appreciated.

I will see if that also fixes similar issues with Access 2010.

Author Closing Comment

ID: 39608099
I was able to find an article which fixed the problem

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This article will show how Aten was able to supply easy management and control for Artear's video walls and wide range display configurations of their newsroom.
Simple Linear Regression
Six Sigma Control Plans

587 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