I have a small website that uses files from a web development package,
Word docs and Excel spreadsheets saved in htm files. I link from one
to the other but my spreadsheets now have multiple worksheets in them
and the links form Word only go to the first tab/worksheet.

I go into the hyperlink feature and choose Existing File or Webpage and
enter the url for my spreadsheet, Is there a way to modify the url I
enter so that the link takes me to a worksheet other than the first
one?

Thanks for your help.




--
bob278

To open the workbook at Sheet3!Z99 append #Sheet3!Z99 to the hyperlink
address.
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Bill Manville;2674912 Wrote:
To open the workbook at Sheet3!Z99 append #Sheet3!Z99 to the hyperlink
address.
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Thank you Bill. Here is the entry I made in the address field. Even
though the url shown in the browser address field included this
information, it opened the file at the first sheet. It opens exactly
the same with or without the text after "htm". I'm sure this is
operator error, but I don't know what I am doing wrong. My browser is
Firefox but I've also tried it on my wife's computer with IE. We both
have Windows Vista. Any suggestions? Thank you again.

As entered in Word [http://tinyurl.com/yo39mk

As displayed in browser
http://tinyurl.com/yo39mk




--
bob278

Hmm.
You have me confused.
I thought you were linking to an Excel workbook but you seem to be
linking to a .htm file. And the 2 URLs you gave me seem to be
identical.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Bill, I was afraid I might confuse you. What I was trying to say was
that I put a url in the hyperlink address in the word doc and it did
link to the url as I entered it, but ignored everything after the
"htm".

What I have is a Word doc that I save as a webpage. Within that page,
I have links to the spreadsheet that I also save as a webpage. I ftp
both of them to a webhost for access, along with several other files.

In the Word doc, I want to link to the spreadsheet and that works. But
it goes to what ever sheet happened to be open when the spreadsheet was
saved. I need for it to go to a particular sheet depending on which
link was selected. In the "source" page, http://tinyurl.com/yoytk4

the top cabin link (7172) should go to deck7 tab in the spreadsheet and
the next one down (9594) should go to the deck9 tab. Both go to the
index tab as that is what was active when I saved it. The spreadsheet
url is: http://tinyurl.com/256omk

You have no idea how grateful I am that you are trying to help me. My
alternative is to have an individual spreadsheet saved as htm for all
the tabs and maintaining 9 files is far more trouble than just one. I
sure hope what I want to do is possible. I need to be able to do this
using the functionality built in as I do not know vb programming.

Thank you so much.




--
bob278

Hi Bob

If the person reading the webpage has Excel then your link could be to
the XLS file with the sheet!range as a sub-address and the workbook
would be opened by Excel operating within the browser showing the
correct sheet (at least for Internet Explorer; I have no knowledge of
others).

But I guess you can't rely on the reader having suitable software.
I don't think you can avoid saving individual worksheets as separate
html files and linking to each such file separately.

But I am not an expert in the html area

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Bill,

I was afraid of that. Since the url does not change depending on the
sheet that gets opened, I guess the entire multi-sheet spreadsheet is
one file with internal links.

I appreciate all the time you took to try to help with this.




--
bob278