OPEN TAB!

Posted by Hy Huynh on January 09, 2002 11:37 PM

Hi,

I have several Excel files with more than one tab from which I would like to open a specific tab from a link in HTML/Javascript/ASP. Can this be done??

Thanks
Hy Huynh

Posted by Chris D on January 10, 2002 6:03 AM

Do you mean, for example, open the sheet called "Buildings" within the worksheet called "Planning.xls" via an HTML hyperlink in an HTML page called "homepage.html" ?

Posted by Hy Huynh on January 10, 2002 6:27 AM

thats the exact what i mean...any suggestions??

Posted by Chris D on January 10, 2002 10:52 AM

remember in HTML where you can assign an "anchor" to any part of the webpage.... you can then link to that anchor :

(where "{" = "&LT;" and "}" = ">")

{A HREF="filename#anchorname"}description{/A}

all you do is choose cell A1 in the worksheet you want displayed (Buildings) and give it a range name of, say, "here".

then : the HTML syntax in your homepage.html file will be as follows :

{A HREF="Planning.xls#here"}link description{/A}

Luckily, naming a range in Excel seems to act as the same procedure as naming an anchor in HTML !

Good deal...

Hope this helps and works - I tried it on my machine and it seemed to

Chris
:-)

Posted by Hy Huynh on January 10, 2002 11:53 PM

::heyyy..it works!! thx chris :)