IE link to a sheet

A

Ara

Does anyone know how I can link to a specific sheet within
Excel from IE? I am doing this from .asp on IIS.

The following pulls Excel up nicely in its own application
but doesn't show the proper sheet (it just loads with
whatever sheet was active at last save)

<A href="Book1.xls.lnk#Sheet2!A1">Sheet2</a>

I know how to get the proper Excel sheet loaded within IE
but I'd rather have Excel run in its own application. I
basically need to link from IE, open up Excel in its own
app with the proper sheet focused, go back to IE, link to
another sheet in the same Excel instance, etc... The
example above works great since it only opens one instance
of Excel, but for some reason the sheet link doesn't work.

p.s., if you're wondering what the .lnk extension is at
the end of the filename, it means that I'm actually
linking to a shortcut of the file (this was the only way I
could get it to load in Excel and not embed in a browser)
Thanks!
 

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