ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Hyperlink from HTML to a specific Excel workshhet (https://www.excelbanter.com/excel-programming/437189-hyperlink-html-specific-excel-workshhet.html)

WayneO

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



Gary''s Student

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




All times are GMT +1. The time now is 09:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com