Linking to a single Excel worksheet

[CaryRW]

I am thinking there has to be a way to do this, but I have yet to figure it out.

I want to have a single Excel workbook with multiple tabs. I then want to have links call the individual worksheets in the workbook, so that no one link can see more than the worksheet I specify.

Any and all advice/help would be greatly appreciated!!!

Cheers.


Cary

[AdamGundry]

Are you linking to the XLS file, or converting it to HTML files? If the latter, you could simply link to the appropriate file only.

Adam

[CaryRW]

I want to link to the XLS file. We are going to be making changes to the XLS file and so I don't want to have to re-publish all the HTML pages.

[AdamGundry]

I don't know how you can link to a particular worksheet, except from within Excel itself. Anyone else got any ideas?

Adam

[khaki]

hi Cary (and Adam)...

you can link to specific portions of an Excel file by creating "Named Ranges" in the Excel file.

the Named Ranges then become the equivilent of a Table Name for SQL purposes...
and by using ASP/SQL... you can extract whatever data or information you want out of any part of an Excel file.

one thing though...
Excel is a tricky data source... because it can not really handle concurrent users.

a fairly good work-around for that would be to create an Access Database which is linked to the Excel data...
and then you could use the Access DB as the data source.

in a nutshell...
this solution involves ASP capability, SQL, and either Excel or Access (preferably).

so then... the only remaining question is:
is this something that you would want to do?

if so... let me know and i'll try to help walk you through it.

;) k

[CaryRW]

ASP and SQL are not really my bag, but I am sure I can handle Excel and Access. I already have some Access databases for other applications. I also have SQL server available to me as well, if that is easier. If you have some references that I can use and/or examples, I learn pretty quick.

I would really appreciate any help and advice!! Thanks!


Cheers.

[khaki]

hi Cary...

give me a little bit...
and I'll post some examples for you.

i just gotta run and do something real quick.
be back shortly (so stay tuned).

;) k