Hi there Brad
I have had almost exactly the same problem. After several e-mails to both
this list and MapInfo TechSupport I finally got the answer. Cindy at
TechSupport fiddeled around with the problem and found out that if you
create 'named ranges' in your Excel file (Block the area needed -> select
'Insert' -> 'Name' -> 'Define...') then this name shows up in the list when
trying to open the file. You can copy the code from the .TAB file that is
created and use it in MapInfo.
If you need more detailed info, feel free to mail me.
Johann
> -----Original Message-----
> From: GeoInfo Solutions Ltd. [SMTP:[EMAIL PROTECTED]]
> Sent: 12. august 1999 04:23
> To: [EMAIL PROTECTED]
> Subject: MI MB: How to open a specific Excel worksheet in MapBasic
>
> I would like to open an Excel worksheet but the MapBasic manuals only
> indicate how to register an excel *.xls file if you give mapbasic the name
> of the range or worksheet. But MapInfo can read the available worksheets
> and the ranges in these worksheets that contain data or have formatting.
>
> So one would hope that MapBasic could duplicate this MapInfo functionality
> and enable a programmer to read the available worksheet names in a chosen
> xls file.
>
> Am I missing something in the MapBasic manual?
>
> I have checked the MS knowlege base, the MB sample code on the install CD,
> and Thoen's list of uploads.
>
> What is the secret MapInfo?
>
> Thanks,
>
> Brad Judson
>
>
> GeoInfo Solutions Ltd.
> mailto:[EMAIL PROTECTED]
> http://www.geoinfosolutions.com
> phone/fax 250-656-7170
> ----------------------------------------------------------------------
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
