Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 10 of 10

Integrating Virtual Earth Maps and Excel 2007

This is a discussion on Integrating Virtual Earth Maps and Excel 2007 within the Bing Maps Blogs & Tweets forums, part of the Blogs category; About a month ago, Google released integration between Google Earth and Google Spreadsheets . Then, they release Google Spreadsheet Mapper ...

  1. #1
    VirtualEarth MSDN Blog is offline Senior Member Blue Belt
    Join Date
    Sep 2007
    Posts
    379

    Integrating Virtual Earth Maps and Excel 2007

    About a month ago, Google released integration between Google Earth and Google Spreadsheets. Then, they release Google Spreadsheet Mapper to make it official. Very cool idea. We had native integration between MapPoint 200x and Microsoft Office Excel, but no one had done much to pull Virtual Earth and Excel together. Actually, IDV Solutions', Ian Clemens wrote "Connecting Excel Spreadsheets and Virtual Earth" like a couple days after Google announced their integration, but Microsoft didn't do anything official. Well, that's changed; at least, for developers.

    We've just published "Integrating Virtual Earth Maps and Excel 2007 Using Visual Studio 2005 Tools for Office Second Edition" on MSDN as a two part article. Part 1 is summarized as, "Develop and implement a business intelligence application quickly with Microsoft Visual Studio 2005 Tools Second Edition for the 2007 Microsoft Office System, Virtual Earth Map Control 6.0, and Microsoft Office Excel 2007. (28 printed pages)."

    Part 2: Integrating Virtual Earth Maps and Excel 2007 Using Visual Studio 2005 Tools for Office Second Edition (Part 2 of 2) is summarized as "a two-part series. Learn how to add data to a Microsoft Office Excel 2007 worksheet using automation to format cells as well as create charts and send data for pushpins on the map and export charts images. (43 printed pages)." You can download the code samples from MSDN too - Integrating Virtual Earth Maps and Excel 2007 Using Visual Studio. That's a little novella. 

    So, if you're a developer looking to integrate Virtual Earth and Microsoft Office Excel you should take a gander at this article as this will help visualize your data like you've never seen before. Also, there will be some nice integration points between SQL Server 2008 and Excel which you can then publish to Virtual Earth (again, if you're a developer). Although, perhaps an Excel developer will create an add-in that we can just export to Virtual Earth or Live Search Maps? Users, ask your IT folks to get this hooked up for you - pri 1..

    And, for those of you using Google Spreadsheet Mapper, you can take those KML files you've created and use them in Virtual Earth natively to visualize your data in our higher resolution ortho and oblique (Bird's Eye) photography and our in browser 3D experience. We support KML in both Live Search Maps and Virtual Earth. Huge ups to the folks at Advaiya, Inc. for authoring this.

    CP


  2. #2
    Peter.Sie is offline Junior Member White Belt
    Join Date
    Oct 2008
    Posts
    1

    Re: Integrating Virtual Earth Maps and Excel 2007

    Hi,

    I wonder if anyone has a Excel 2007 VBA sample accessing Virtual Earth from VBA code.

    Peter Sie, Downunder.

  3. #3
    tomgreag is offline Junior Member Yellow Belt
    Join Date
    Aug 2008
    Posts
    17

    Thumbs up Re: Integrating Virtual Earth Maps and Excel 2007

    I Have but how can i send it to you??

  4. #4
    MapAdmin is offline Senior Member Green Belt
    Join Date
    Sep 2007
    Posts
    106

    Re: Integrating Virtual Earth Maps and Excel 2007

    Hi Tom,

    You can post the spreadsheet as an attachment. Under Additional Options below, you can click "Manage Attachments". You may need to zip the Excel file first.

    Also, you can paste all the code into a code. You can use the "code" tags to preserve the indentation. Here's an example

    Code:
     
    'This is code
       'Indented code

  5. #5
    sous2817 is offline Junior Member White Belt
    Join Date
    Jan 2011
    Posts
    3

    Re: Integrating Virtual Earth Maps and Excel 2007

    Hello everyone,

    I'm new to the forums, so please go easy on me. I was hoping someone would be willing to post some examples of how to integrate the Virtual Earth Maps in to Excel 2007.

    I tried going through the posts, but didn't have much luck (a lot of compiling errors when I tried to build the add-in. Also, the Access data wasn't included in the sample downloads).

    Ultimately what I was hoping to do was to create a fancy looking thematic map in Excel 2007, using data in 2007 ranges to hightlight the countries.

    Any help would be greatly appreciated.

    Thanks in advance!

  6. #6
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4

    Re: Integrating Virtual Earth Maps and Excel 2007

    I think it would be a lot easier to use the Desktop Version of MapPoint. Have you considered it? or why do you want to use Bing Maps?

    Eirc
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  7. #7
    sous2817 is offline Junior Member White Belt
    Join Date
    Jan 2011
    Posts
    3

    Re: Integrating Virtual Earth Maps and Excel 2007

    I thought about MapPoint, but the document I'm working on would be shared among several users on a network and it wouldn't be feasible for everyone to have MapPoint installed on their machine(s).

  8. #8
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4

    Re: Integrating Virtual Earth Maps and Excel 2007

    What if you created several static map images for them? The solution in this article is not necessarily for mobile devices, it could put image files out on your network --

    Automatically Publishing MapPoint Maps to Mobile Devices

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  9. #9
    sous2817 is offline Junior Member White Belt
    Join Date
    Jan 2011
    Posts
    3

    Re: Integrating Virtual Earth Maps and Excel 2007

    Thanks Eric! I'll give it a go and see what I can come up with.

  10. #10
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4

    Re: Integrating Virtual Earth Maps and Excel 2007

    There's a free MapPoint 2010 trial download

    MapPoint 2010 Trial Version Download! - MapPoint Forums

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Integrating Virtual Earth and GeoNames
    By Johannes Kebeck's Blog in forum Bing Maps Blogs & Tweets
    Replies: 0
    Last Post: 03-30-2008, 11:00 AM
  2. Integrating Virtual Earth and MapPoint Web Service
    By Johannes Kebeck's Blog in forum Bing Maps Blogs & Tweets
    Replies: 0
    Last Post: 03-30-2008, 06:51 AM
  3. Virtual Earth, January 2007
    By MapAdmin in forum Bing Maps Newsletter
    Replies: 0
    Last Post: 02-14-2008, 10:25 AM
  4. Integrating Microsoft Virtual Earth Maps into a Sharepoint Site
    By VE For Government in forum Bing Maps Blogs & Tweets
    Replies: 0
    Last Post: 01-08-2008, 03:11 PM
  5. Virtual Earth News from GEOINT 2007: Virtual Earth Appliance
    By VE For Government in forum Bing Maps Blogs & Tweets
    Replies: 0
    Last Post: 10-24-2007, 12:10 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127