Displaying Google Earth in UserForm

**Torran** · 06-15-2014, 11:42 AM

Greetings I'm new to this community and I hope you guys can help me with a problem.

I'm doing distance calculation between Airports (great circles) and I want the results to be displayed within the UserForm.

My idea was to create an html file with vba that uses javascript to access the google earth plugin. so far this html file works perfectly in every browser.
Just the Microsoft Web Browser Plugin in Excel won't display it.

When I hit the "show"-button, the window keeps white and displays a warning about active content that could access my pc blabla....

I can ignore the warning. Next thing happening is an error that tells me that this bit of the code is undefined:

<!DOCTYPE html>
<html>
<head>
<meta http-equiv="X-UA-Compatible" content="IE=9">
<title>Google Earth API Samples - Creating Line Strings</title>
<script type="text/javascript" src="http://www.google.com/jsapi?hl=en&key=ABQIAAAAwbkbZLyhsmTCWXbTcjbgbRSzHs7K5SvaUdm8ua-Xxy_-2dYwMxQMhnagaawTo7L1FE1-amhuQxIlXw"></script>
<script type="text/javascript">
/* <![CDATA[ */
var ge;
google.load("earth", "1");
//_________________________________________________________________________________
function init() {
google.earth.createInstance('map3d', initCB, failureCB);
}

When I answer the question: "Do you still want to run this script?" with yes. I get a white page with the outlined borders of where Google Earth is supposed to be displayed

And now my questions are:

Is there a different browser plugin aviable for Excel?
If not, what do I need to do, to get this page displayed?
Is there another solution? I don't want to load this page in an external browser, and I also don't want to start Google Earth directly.

Thanks in advance

Torran

Displaying Google Earth in UserForm

LinkBack

Thread Tools

Rate This Thread

Display

Threaded View

Displaying Google Earth in UserForm

Thread Information

Users Browsing this Thread

Similar Threads

Excel to Google Earth

Google Earth lat./long. import to Excel

Excel 2007 : Excel 2007 opens Google Earth with certain commands

Is it possible to upload an excel address into Google Earth?

Excel to Google Earth made easy

Bookmarks

Bookmarks

Posting Permissions