#1   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 1
Default Hyperlink help


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
  #2   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 473
Default Hyperlink help

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

  #3   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 1
Default Hyperlink help


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
  #4   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 473
Default Hyperlink help

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

  #5   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 1
Default Hyperlink help


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


  #6   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 473
Default Hyperlink help

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

  #7   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 1
Default Hyperlink help


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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't make hyperlink function work for hyperlink to website Frank B Denman Excel Worksheet Functions 15 February 6th 07 12:01 AM
How do I create a hyperlink to a cell with the hyperlink function S. Bevins Excel Worksheet Functions 2 July 20th 06 08:06 PM
Moving rows with Hyperlink doesn't move hyperlink address Samad Excel Discussion (Misc queries) 15 June 22nd 06 12:03 PM
Hyperlink from one sheet to the hyperlink on another AO Excel Discussion (Misc queries) 2 July 5th 05 11:27 AM
Intra-workbook hyperlink: macro/function to return to hyperlink ce marika1981 Excel Discussion (Misc queries) 3 May 6th 05 05:47 AM


All times are GMT +1. The time now is 08:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"