View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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