locked
Need help understanding how to use iframe and webbrowser object inside Excel RRS feed

  • Question

  • I'm running Excel 2013 and trying to make use of some VBA code that was developed for Excel 2010.

    The code in question has some lines that look like this:

    Worksheets(1).WebBrowser1.Navigate Range("myActualURL").Value

    Where the range holds a Google Maps URL with lattitude and longitude which can vary based upon user selection.  For example:

    http://maps.google.com/maps?ll=27.986519,86.919708&spn=.429142,.595562&t=k&hl=en&output=embed

    Initially that did not work, and I found a kb article that said you need to modify this registry key value from 1024 to 0:

    HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\15.0\Common\COM Compatibility\{8856F961-340A-11D0-A96B-00C04FD705A2}

    Making that change got past the run time error 438 (Object doesn't support this property or method), but then I got a different error message, which said:

    The Google Maps Embed API must be used in an iframe.

    So how do you write the VBA code to package the webbrowser object inside an iframe?


    • Edited by Pete Kies Tuesday, July 12, 2016 3:15 AM
    Tuesday, July 12, 2016 3:05 AM