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

Signature
bob278
Bill Manville - 16 Mar 2008 00:39 GMT
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
bob278 - 16 Mar 2008 04:56 GMT
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.

Signature
bob278
Bill Manville - 16 Mar 2008 09:36 GMT
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
bob278 - 16 Mar 2008 16:09 GMT
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.

Signature
bob278