Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlink from HTML to a specific Excel workshhet
We have html files with links in them that open an Excel document and goes to
a specific worksheet. Since upgrading from Office 2003 to Office 2007 we now find that the link will only open the workbook to its last saved active worksheet and not the worksheet required. Does anyone know how to get around this? HTML Syntax is <a href="c:\temp\book1.xlsx#Sheet3!A1" LableName </a |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlink from HTML to a specific Excel workshhet
Using 2007 I created a tiny workbook called master.xlsx The only thing in
master is a hyperlink to another workbook, specific sheet, specific cell. I saved master as html. When I open the htlm in IE, the hyperlink works. Examine the html in NotePad to see the syntax. (to me the htlm is just gibberish) -- Gary''s Student - gsnu200909 "WayneO" wrote: We have html files with links in them that open an Excel document and goes to a specific worksheet. Since upgrading from Office 2003 to Office 2007 we now find that the link will only open the workbook to its last saved active worksheet and not the worksheet required. Does anyone know how to get around this? HTML Syntax is <a href="c:\temp\book1.xlsx#Sheet3!A1" LableName </a |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink from HTML to a specific Excel Worksheet | Excel Programming | |||
Hyperlink from html to specific worksheet | Excel Discussion (Misc queries) | |||
Hyperlink to specific sheet; workbook saved as html | Excel Worksheet Functions | |||
From HTML open a specific worksheet within a excel file | Excel Programming | |||
reading html when hyperlink address not hyperlink text diplayed | Excel Programming |