Hyperlink to a specific worksheet?

G

Glenn Mulno

Hi All,

Is it possible to create a hyperlink on a web page that when clicked it will
open a specific worksheet of a specific Excel document?

Not that it works but I was thinking it may look something like this:

<a href="file://server/ReportOutput/MyFile.xls#Sheet1"> Click </a>
 
F

Frank Kabel

Hi
untested but try:
<a href="file://server/ReportOutput/MyFile.xls#'Sheet1'!A1"> Click </a>
 
G

Glenn Mulno

Thanks Frank. That's along the lines of what I was thinking should work but
it does not. I'm not sure if it can be done but I always believe these can
be and many times they can. I spent about 3 hours going through online help
and other resources today trying to find a way but keep coming up blank.

Anyway - thanks again. I'll keep plugging away at it to see if I can find
something.

--
Glenn


Frank Kabel said:
Hi
untested but try:
<a href="file://server/ReportOutput/MyFile.xls#'Sheet1'!A1"> Click </a>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top