"classic" google maps not working in vba webbrowser control

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
donald_musickAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
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.

Solution:


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"


See:
Mark of the Web
http://msdn.microsoft.com/en-us/library/ms537628%28v=vs.85%29.aspx
 
Enhanced Protected Mode and Local Files
http://blogs.msdn.com/b/ieinternals/archive/2012/06/20/loading-local-files-in-enhanced-protected-mode-in-internet-explorer-10.aspx

FYI:
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!
1
donald_musickAuthor Commented:
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).
0
donald_musickAuthor Commented:
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:

http://www.west-wind.com/weblog/posts/2011/May/21/Web-Browser-Control-Specifying-the-IE-Version

http://wiki.imacros.net/IE9_Nags#What_IE_compatibility_mode_does_the_webbrowser_control_use.3F
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
Thanks for sharing the solution!   It is much appreciated.

I will see if that also fixes similar issues with Access 2010.
0
donald_musickAuthor Commented:
I was able to find an article which fixed the problem
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.