setting a specific worksheet to open when accessing an excel file

B

BeeMan

Hey all,

I'm wondering how I can open up an excel file and somehow make it s
that when I open up the file it'll point to a specific worksheet.

ie. if I had a huge excel file and was sending an web address t
someone to see a specific part of that file, how do I extend th
address to include that information.. eg
http://somewerver.com/myexcelfile.xls,worksheet5 ??

Thank you for your time,

BeeMa
 
D

Dave Peterson

I don't speak HTML, but maybe something like this will help:

<a href="file:////c:/yourfolder/book1.xls#'sheet 1'!A1">click me</a>
 
Top