MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




Linking Data within an Excel Workbook to Mappoint

This is a discussion on Linking Data within an Excel Workbook to Mappoint within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; I have an Excel Report Writer and I am trying to link data from the Worksheet into Mappoint for datashapes ...


Go Back   MapPoint Forums > Map Forums > MapPoint 2006/2009 Discussion

Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 07-06-2005
Junior Member
White Belt
 
Join Date: Jul 2005
Posts: 1
Linking Data within an Excel Workbook to Mappoint

I have an Excel Report Writer and I am trying to link data from the Worksheet into Mappoint for datashapes but I keep getting connection errors. Here is my code. I haven't started the shapes as I can't get the data into the Map.

Any help would be appreciated.

Jim

Dim objApp As New MapPoint.Application
Dim objDataSet As MapPoint.DataSet
Dim objDataMap As MapPoint.DataMap
Dim szconn As String
'Set up application and objects to use
objApp.Visible = True
objApp.UserControl = True
szconn = "Activeworkbook.activesheet!A4:A6"
Set objDataSet = objApp.ActiveMap.DataSets.LinkData(szconn, "F1", , geoCountryUnitedStates, , geoImportExcelNamedRange)
objApp.ActiveMap.MapStyle = geoMapStyleData
objDataSet.DisplayDataMap ' necessary to allow editing in the next line


objApp.ActiveMap.DataSets.ShowDataMappingWizard _
DataSetToUse:=objDataSet
'Get the new data map
Set objDataMap = objDataSet.DataMap
'Set the title
objDataMap.LegendTitle = "User-created data map"


Thanks
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
Importing or linking data alwasl8 MapPoint 2006/2009 Discussion 0 06-21-2005 12:47 PM
Linking to Weather Data From MapPoint Anonymous MP2K Magazine Articles 1 11-01-2004 07:24 AM
Linking Excel with Mappoint whs28175 MapPoint 2006/2009 Discussion 1 11-20-2003 05:03 AM
Exceeding 8 ranges when linking data Anonymous MapPoint 2006/2009 Discussion 1 01-24-2003 09:49 PM
How can I find a past article on linking Excel & M.... Anonymous MapPoint 2006/2009 Discussion 1 11-07-2001 05:14 PM


All times are GMT -5. The time now is 06:25 AM.


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0
MP2K Magazine
Visitor Map

Bulgaria Ski Holidays
First time skier? Looking for something a little different? Bulgaria Ski holidays could be the perfect remedy to your winter blues. Bulgaria prices are great value.

Tailor Made Holidays
Late deal holidays and tailor made holidays can easily be arranged by an independent travel agent like Travel Counsellors.

Holidays Cuba
When you book holidays in Cuba you will find a fascinating country with a heady combination of Spanish, African and Caribbean influences. Check our great deals.

Maldives Holidays
If you are looking for a serene, laid back break in the sunshine, Maldives holidays are the choice for you. Be enchanted by the Maldives!

Spain
Spain is such a diverse country that it has something to offer most holidaymakers. Finding delicious cuisine is no challenge and the shopping ranges from designer boutiques to unknown flea markets. Spain has much to offer.

Travel Deals
Click here and read up on the travel deals available online.

Cheap Sharm Holidays
Get info on cheap Sharm holidays at On The Beach, and enjoy Egyptian nightlife!


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