Back to excel

Dear mappointers,

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

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.


'Excel sheet R1C1 reference
szconn = objApp.Path & "\Samples\Sales.xls!Sheet1!R1C1:R3C9"
Set oDS = .ImportData(szconn, , geoCountryUnitedStates, , geoImportExcelR1C1)

Thanks, but what I mean is can i get a link in my Data Set properties
to a certain range in excel. I can get a link to an excelsheet but not to a range in that sheet.

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

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?