Link to home
Start Free TrialLog in
Avatar of PaulBukowski
PaulBukowski

asked on

Link to an Excel Worksheet ???

Hi,
 
I'm building a web page and would like to set up a link to an Excel spreadsheet. However, I'd like the link to point to a SPECIFIC worksheet inside the Excel workbook. Example; Test.xls (sheet 5). What code can I use to accomplish this ? I'm currently using the following HTML: HREF="C:\HTML DESIGN\Test.xls">
 
Any ideas would be greatly appreciated.
 
Thanks,
Paul
 
Avatar of egbservices
egbservices
Flag of Australia image
No comment, no answer... I am just interested in the outcome. EdiI
Avatar of coopa
coopa
I believe if you save the excel document whilst viewing worksheet 5, then the page will open that worksheet by default.... I'm going to check now...
Avatar of coopa
coopa
Just tested it.... it seems to work  

8o)
Avatar of ruperts
ruperts
(EdiI - if you just want to keep up to date with the question, select comment and the just press submit! You don't need to actually add any comments.)
Avatar of ruperts
ruperts
(EdiI - if you just want to keep up to date with the question, select comment and the just press submit! You don't need to actually add any comments.)
Avatar of cybernietic
cybernietic
<a href=file:///C|/HTML DESIGN\Test.xls>Test.xls</a>
I don't think it's possible to open a document at a given sheet
Avatar of coopa
coopa
cybernietic, if you read the rest of the post you could have saved all that typing.  

8o)
ASKER CERTIFIED SOLUTION
Avatar of Hocam
Hocam
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of scalton
scalton
Microsoft documentation says:
<A HREF="C:\HTML DESIGN\Test.xls#Sheet5">Sheet 5</HTML>

and then you define that name in a cell on that sheet.

I've never got it to work.

See: http://support.microsoft.com/support/kb/articles/Q197/9/22.ASP