1 file multiple worksheets

D

dismas

I have a workbook with 30 worksheets in it.
I need to be able to open it from a web link using the same file, bu
each link able to open to a specific worksheet.

Is there a way to open a saved workbook by adding a suffix to th
specific worksheet.

I have tried several things but none work. Here are some examples tha
may clarify what I am asking.

The saved file is workbook.xls

workbook.xls#sheet4
workbook.xls!sheet 6


Thanks,
Disma
 
D

Dave Peterson

I don't speak HTML, but in MSWord, I can put a hyperlink that looks like this:

C:\My Documents\excel\book1.xls#sheet1!c9

Maybe you can have 30 different links--each slightly different.
 
L

Lady Layla

Unfortunatley Dismas, the set IE to empty temp file when closed does nothing.

: Bravo Dave! Thanks for your help.
: This works for me.
:
: Here is an additional problem that I have encountered.
:
: If the file is left in cache, IE wont load the next tab selection that
: may be contained in another an additional url.
:
: To access the same workbook successively, hitting different worksheet
: tabs...I have to keep the workbook from staying in cache memory:
:
: I have turned off history in IE and set IE to empty the temp file when
: the browzer is closed.
:
: This works but I am wondering if anyone knows of a more robust way of
: handling this problem.
:
:
:
: Thanks,
: Dismas
:
:
: ---
:
:
 
Top