MapForums
Community of VE/MapPoint Users and Developers
using an excel record as a variable
This is a discussion on using an excel record as a variable within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; I export (programmatically) from excel to mappoint. There are, say, four fields: Order number; Name; Postcode; week number. This maps ...
| |||||||
| Register | Blogs | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-07-2004
| |||
| |||
| using an excel record as a variable There are, say, four fields: Order number; Name; Postcode; week number. This maps fine. I am trying to associate the week number of each record with a pushpin symbol number. How do I use or access the individual records in the fields? I have thoroughly searched your Q &A, picked up many tips, but no clues to solve this problem. I am fairly new to programming. I have tried to adapt this code but can only get field names. Code: Sub GetAllFieldNames()
Dim objApp As New MapPoint.Application
Dim objDataSet As MapPoint.DataSet
Dim objFld As MapPoint.Field
Dim strFldNames As String
'Set up the application
objApp.Visible = True
objApp.UserControl = True
'Let user create a data map
objDataSet = _
objApp.ActiveMap.DataSets.ShowImportWizard
'Loop through all available fields for their names
For Each objFld In objDataSet.Fields
strFldNames = strFldNames & objFld.Name & vbCrLf
Next
MsgBox "DataSet field names: " & vbCrLf & strFldNames
End Sub
Many thanks         |
 |
| Tags |
| excel, record, variable |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Are there any workarounds for the 10000 record lim.... | Anonymous | MapPoint 2006/2009 Discussion | 2 | 03-23-2005 06:01 PM |
| Color coding locations by some variable, i.e. sales dollars | mr4tno | MapPoint 2006/2009 Discussion | 0 | 02-17-2005 10:15 AM |
| gps record | bchara | MapPoint 2006/2009 Discussion | 0 | 07-23-2004 08:31 AM |
| 50,000-record limitation | Anonymous | MapPoint 2006/2009 Discussion | 2 | 02-06-2004 11:41 AM |
| PUSHPIN RECORD LIMIT | gsc1ugs | Products: Pushpin Tool, Single State Mapper | 2 | 03-07-2003 11:00 AM |
All times are GMT -5. The time now is 12:02 PM.
