The all you would need is to add a frame name target to the links in my post
Start by linking to the workbook to make sure you have the paths & link correct
- then adjust it to the worksheet
_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
_____________________________________________
| Yes!
|
| I am using a 2 frame set, upper and lower where the upper frame contains the
| links and the lower frame displays the spreadsheet.
|
| Dave
|
|
| | > If I understand
| > You have a web open in FP
| > In the FP web (under the root) you have a folder named: trg_2004
| > In that folder you have the excel .htm file named: 2004d.htm
| > That means you have a hidden cluster folder in that same folder named:
| 2004d_files
| > So a link from a page in the root web (say your home page) to the
| excel.htm would be
| > <a href="trg_2004/2004d.htm>Excel 2004 File</a>
| > and a link to the 2nd worksheet in that file would be
| > <a href="trg_2004/2004d_files/sheet002.htm>Excel 2004 File, Sheet
| 2</a>
| >
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| >
http://www.net-sites.com/sitebuilder/newsgroups.asp
| > _____________________________________________
| >
| >
| | > | Ok - I am still not there:
| > |
| > | I changed the folder and file names from
| > | Folder name - Training 2004 to trg_2004
| > | File name - 12 month 2004d.htm to 2004d.htm
| > |
| > | Sheet 2 is stored in 2004d_files as sheet002.htm - This was created by
| Excel
| > | when I converted the xls to a htm file
| > |
| > | So the file structure for the link is
| > | webroot/trg_2004/2004d_files/sheet002.htm
| > |
| > | Is this link correct? Do I link directly to the sheet created by excel?
| > |
| > | Thanks for the help.
| > |
| > | | > | > Resave your html from excel and remove all spaces and / in the file
| name,
| > | the file import it again
| > | > Looks like you now have an excel .htm named something like:
| > | > "Training 2004/12 month 2004d.htm"
| > | > Rename it to say
| > | > "Training_2004_12_mo_data.htm"
| > | > in which case the code would be
| > | > <a target="main" href="Training_2004_12_mo_data_files/sheet003.htm">
| > | >
| > | > PS
| > | > Also could be the link is actually shorter because your file name is
| so
| > | long
| > | > Try a shorter name like
| > | > "Training04data.htm" for a link like
| > | > <a target="main" href="Training04data_files/sheet003.htm">
| > | >
| > | > --
| > | >
| > | > _____________________________________________
| > | > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > | > "Warning - Using the F1 Key will not break anything!" (-;
| > | > To find the best Newsgroup for FrontPage support see:
| > | >
http://www.net-sites.com/sitebuilder/newsgroups.asp
| > | > _____________________________________________
| > | >
| > | >
| > | | > | > | I posted the original in html - sorry - this is text
| > | > |
| > | > |
| > |
| onmouseup="FP_swapImg(0,0,/*id*/'img3',/*url*/'images/button6.jpg')"></a><a
| > | > | target="main"
| > | > | href="Training%202004/12%20month%202004d_files/sheet003.htm"><img
| > | border="0"
| > | > | id="img6" src="images/button29.jpg" height="30" width="110"
| > | alt="National
| > | > | Classes" fp-style="fp-btn: Soft Tab 5; fp-proportional: 0"
| > | > | fp-title="National Classes"
| > | > |
| > | > |
| > | > | | > | > | > Post the URL to your page online or a code snippet showing your
| > | hyperlink
| > | > | tag
| > | > | >
| > | > | > --
| > | > | >
| > | > | > _____________________________________________
| > | > | > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > | > | > "Warning - Using the F1 Key will not break anything!" (-;
| > | > | > To find the best Newsgroup for FrontPage support see:
| > | > | >
http://www.net-sites.com/sitebuilder/newsgroups.asp
| > | > | > _____________________________________________
| > | > | >
| > | > | >
| > | > | | > | > | > | I appreciate your help.
| > | > | > |
| > | > | > | I am using frames and FP2003, I don't know if this is the issue.
| > | > | > |
| > | > | > | I set the link in the upper frame. When I mouse over the link,
| I
| > | get
| > | > | the
| > | > | > | address of sheet002.htm. When I mouse over corresponding sheet
| tab,
| > | I
| > | > | get
| > | > | > | the exact same link.
| > | > | > |
| > | > | > | If I click the Second Sheet Tab all is well. If I click the
| link I
| > | > | created,
| > | > | > | is launches the spreadsheet htm page, not the correct sheet of
| that
| > | > | > | spreadsheet.
| > | > | > |
| > | > | > | I know that I am missing something.
| > | > | > |
| > | > | > | Thanks again
| > | > | > |
| > | > | > | Dave
| > | > | > |
| > | > | > | | > | > | > | > It only works (using the sheet name) if you are linking to a
| .xls
| > | file
| > | > | > | > If you have a workbook w/ worksheets saved as .htm then the
| sheets
| > | are
| > | > | > | hidden windows thicket files
| > | > | > | > When you file Preview in Browser you can see the links by
| mousing
| > | over
| > | > | the
| > | > | > | sheet tabs
| > | > | > | >
| > | > | > | > Each work sheet is in a hidden thicket folder named
| Workbook_files
| > | > | > | > (where "Workbook" is your file excel.htm filename w/o the
| > | extension)
| > | > | > | > And the sheet htm pages are numbered from 001 to 00X, as
| > | sheet001.htm
| > | > | thru
| > | > | > | sheet00X.htm
| > | > | > | > So a hyperlink to sheet 3 of the workbook myspreadsheet.htm
| would
| > | be
| > | > | > | entered as
| > | > | > | > myspreadsheet_files/sheet003.htm
| > | > | > | >
| > | > | > | > Create a hyperlink to the work book
| > | > | > | > Then edit the hyperlink to add the sheet part
| > | > | > | > --
| > | > | > | >
| > | > | > | > _____________________________________________
| > | > | > | > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > | > | > | > "Warning - Using the F1 Key will not break anything!" (-;
| > | > | > | > To find the best Newsgroup for FrontPage support see:
| > | > | > | >
http://www.net-sites.com/sitebuilder/newsgroups.asp
| > | > | > | > _____________________________________________
| > | > | > | >
| > | > | > | >
| > | > | > | | > | > | > | > | I tried using the sheet name and no luck, but I think this
| will
| > | work
| > | > | if
| > | > | > | I
| > | > | > | > | can figure out how.
| > | > | > | > |
| > | > | > | > | Dave
| > | > | > | > |
| > | > | > | > | | > | > | > | > | > Try using the sheet name as a bookmark
| > | > | > | > | > <a href="workbookname.htm#worksheetname">the sheet</a>
| > | > | > | > | >
| > | > | > | > | > --
| > | > | > | > | >
| > | > | > | > | > _____________________________________________
| > | > | > | > | > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > | > | > | > | > "Warning - Using the F1 Key will not break anything!" (-;
| > | > | > | > | > To find the best Newsgroup for FrontPage support see:
| > | > | > | > | >
http://www.net-sites.com/sitebuilder/newsgroups.asp
| > | > | > | > | > _____________________________________________
| > | > | > | > | >
| > | > | > | > | >
| > | > | > | > | | > | > | > | > | > | I have a 3 page spreadsheet that has been saved as an
| HTM
| > | > | document
| > | > | > | and
| > | > | > | > | > | posted on a site. Everything works fine.
| > | > | > | > | > |
| > | > | > | > | > | However it would be even more user friendly if I could
| link
| > | > | directly
| > | > | > | to
| > | > | > | > | a
| > | > | > | > | > | particular sheet in the spreadsheet. I am using Excel
| 2000
| > | and
| > | > | FP
| > | > | > | 2003.
| > | > | > | > | > |
| > | > | > | > | > | Thanks
| > | > | > | > | > |
| > | > | > | > | > | Dave K
| > | > | > | > | > |
| > | > | > | > | > |
| > | > | > | > | >
| > | > | > | > | >
| > | > | > | > |
| > | > | > | > |
| > | > | > | >
| > | > | > | >
| > | > | > |
| > | > | > |
| > | > | >
| > | > | >
| > | > |
| > | > |
| > | >
| > | >
| > |
| > |
| >
| >
|
|
