ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Hyperlink from html to specific worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/246618-hyperlink-html-specific-worksheet.html)

WayneO

Hyperlink from html to specific worksheet
 
We have html files with links in them that open an Excel document and goes to
a specific worksheet. Since upgrading to Office 2007 we now find that the
link will only open the spreadsheet to its last saved active worksheet. Does
anyone know how to get around this? Syntax is <a
href="c:\temp\book1.xlsx#Sheet1!A1" LableName </a



All times are GMT +1. The time now is 06:11 AM.

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