Geek Answers Handbook

Is it possible to display a map of Google Earth INSIDE Excel?

Is there a way using a script available for Excel 2007 to display a Google Earth map inside a worksheet?

I used Excel to host the data that I had and created a KML file for upload to Google Earth, but now they want to see a pretty small cell with the client address displayed in Excel, the presentation.

+5
source share
3 answers

Microsoft has an ActiveX web browser control that I used in the past, and since Panji explains how to create a web browser control in Excel

html, , WebBrowser Control, , WebBrowser :

  • Excel "".
  • " ".
  • " ". , ActiveX .
  • ActiveX Microsoft WebBrowser Control.
  • , .
  • , .

, . click:

Sub Button3_Click()
    ThisWorkbook.ActiveSheet.WebBrowser1.Navigate2 "http://maps.google.com/maps?f=q&source=s_q&hl=en&geocode=&q=area+51&sll=37.0625,-95.677068&sspn=31.839416,60.732422&ie=UTF8&ll=37.237811,-115.807614&spn=0.015614,0.029655&t=h&z=15"
End Sub

URL.

+10

Google - , , . Excel .

- G- , ​​ / ..

, Google . : http://www.automateexcel.com/2005/07/28/google_maps_in_excel/

0

Google ActiveX ( GEPluginX), Excel, Google ( Google ).

ActiveX API, 3D- ( , KML )...

Google

0

More articles:


All Articles