MapForums
Community of VE/MapPoint Users and Developers
Back to excel
This is a discussion on Back to excel within the Development forums, part of the MapPoint 2006/2009 Discussion category; Dear mappointers, is it possible to get back to a predefined range or cell in an excelsheet from Mappoint through ...
| |||||||
| Register | Blogs | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-09-2008
| |||
| |||
| Back to excel is it possible to get back to a predefined range or cell in an excelsheet from Mappoint through a link. For example in a linked data file:///: C:\Data\Aristo\Gebieden\25STZW1test.xls#sheet2!b3         |
|
04-09-2008
| ||||
| ||||
| Re: Back to excel
Check in the Help File under ImportData, there are four options for Excel including NamedRange and R1C1 syntax.. geoImportAccessQuery DataSourceMoniker specifies an Access query. geoImportAccessTable DataSourceMoniker specifies an Access table. Default. geoImportExcelA1 DataSourceMoniker specifies Excel A1 syntax. Default.geoImportExcelNamedRange DataSourceMoniker specifies an Excel named range. geoImportExcelR1C1 DataSourceMoniker specifies Excel R1C1 syntax. geoImportExcelSheet DataSourceMoniker specifies an Excel worksheet. Default. geoImportFirstRowIsHeadings First row of the file contains field names. Default. geoImportFirstRowNotHeadings First row of the file does not contain field names. There are also some examples in there, e.g. Code:
'Excel sheet R1C1 reference
szconn = objApp.Path & "\Samples\Sales.xls!Sheet1!R1C1:R3C9"
Set oDS = .ImportData(szconn, , geoCountryUnitedStates, , geoImportExcelR1C1)
__________________ Order MapPoint 2006 | Read Programming MapPoint in .NET | Start Using the Pushpin Tool - Free Trial Download - click here. |
|
04-09-2008
| ||||
| ||||
| Re: Back to excel
Sorry I thought you meant import. Maybe you would have to have a macro that reads a parameter you might write to an ini or text file to jump to a location.. Eric
__________________ Order MapPoint 2006 | Read Programming MapPoint in .NET | Start Using the Pushpin Tool - Free Trial Download - click here. |
|
04-10-2008
| |||
| |||
| Re: Back to excel
I have had the same problem. The syntax that was posted bij Kees Kaag works for me, but seems to be cut off after the .xls extension. The pound sign '#' is not interpreted and replacing it by the escaped sting '%23' doesn´t seem to work either. Is this a bug in Mappoint? Who can help launching a .ini or .txt file? |
 |
| ||||
| Posted By | For | Type | Date | |
| The Magazine for MapPoint - MP2K Magazine | This thread | Refback | 04-10-2008 08:56 AM | |
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 |
| Welcome back! | VE Team | Virtual Earth Blogs | 0 | 01-02-2008 04:53 PM |
| OGC - We're Back! | VirtualEarth MSDN Blog | Virtual Earth Blogs | 0 | 10-23-2007 08:42 PM |
| Back from Holiday | VE Team | Virtual Earth Blogs | 0 | 09-15-2007 04:25 PM |
| Data2Map is back! | dkrafcheck | News and Announcements | 0 | 05-15-2006 09:11 AM |
| Exporting Changed data back to Excel | kbeese | MapPoint 2006/2009 Discussion | 0 | 05-17-2005 03:57 PM |
All times are GMT -5. The time now is 01:14 PM.
