According to Microsoft KB article #197922, you can link from a web page to an Excel range with the following HTML syntax:
as long as the link is specified with http: and not file:.
You can either use a named range or a specific Excel range designation.
I have a simple html file on a server:
This code opens the spreadsheet in the same folder on the server read-only, lets me enable macros (I do), but doesn't go to cell B2 on Sheet1 (selection stays where I saved it at cell E7 on Sheet1.
Any idea what's wrong with this picture?
Argh2
Code:
<a href="[URL unfurl="true"]http://sample.microsoft.com/test.xls#Sheet2!MyRange">Third[/URL] link.</a>You can either use a named range or a specific Excel range designation.
I have a simple html file on a server:
Code:
<html>
This is my <a href="[URL unfurl="true"]http://localhost/Test/Test1.xls#'Sheet1'!B2">[/URL] link</a>.
</html>Any idea what's wrong with this picture?
Argh2