How to make url link to sheet in Excel web page ???

D

David Biddulph

If you tell us the URL of the web page, we might be able to help.
http://domain/index_files/sheet004.htm is not valid.

If you save a multi-sheet Excel workbook as a web page, the page will be
something like
http://domain/folder/Book1.htm
and if you want a link to one of the pages it will be
http://domain/folder/Book1_files/sheet002.htm

If you open the http://domain/folder/Book1.htm URL, you should see tabs for
the pages, and if you right-click on one of those, Copy Shortcut will give
you the URL for that sheet.
 
A

akm

If web server directory = /domainname/

'Book1' file is saved as 'test.htm' (has 4 worksheets)

'sheet004.htm' is in '/domainname/test_files/' directory

http://domain.org/test_files/sheet004.htm (shortcut address from test.htm
worksheet tab)
....does not open sheet004.htm

Instead it opens the home page at /domainname/test.htm

Is there a URL that would open sheet004.htm directly ?
 
D

David Biddulph

In my tests when I used the URL
http://www.rowing.biddulph.btinternet.co.uk/priv/Book1_files/sheet002.htm,
although the address line in the browser showed
http://www.rowing.biddulph.btinternet.co.uk/priv/Book1.htm, the page was
opened at the sheet designated by
http://www.rowing.biddulph.btinternet.co.uk/priv/Book1_files/sheet002.htm.

As I said earlier:
"If you tell us the URL of the web page, we might be able to help."
If your files contain confidential information, I would suggest that you
produce a sanitised version as a test, and let us see the URL for that, so
that we can see why it doesn't work for you when it works for us.
 
A

akm

Thanks David.

Per your example, if I were to try to open 'sheet002.htm', the address bar
would show Book1.htm, and I would get 'Book1.htm,' not sheet002.htm... unless
Book1.htm was saved with sheet002 open.

So when you use the URL...
http://www.rowing.biddulph.btinternet.co.uk/priv/Book1_files/sheet002.htm
....and if change the sheet002 to sheet001, sheet003, etc, you are able to
get those separate sheets to open directly ?

Will create a test web page and post that info soon.
 
D

David Biddulph

Ah, that's worrying. I naively assumed that because
http://www.rowing.biddulph.btinternet.co.uk/priv/Book1_files/sheet002.htm
got me to sheet 2, the same would apply to other sheets, but I see that
http://www.rowing.biddulph.btinternet.co.uk/priv/Book1_files/sheet001.htm
also opens the page at sheet 2.

In all honesty, I think it's an html question (or Javascript, or CSS),
rather than an Excel question, but it's not one for which i have an
immediate answer. It may need careful examination of the web page source.
 
A

akm

Thanks David.
Which newsgroup do you suggest to use ?
And/or, is there a good 'html' discussion forum... generally use MajorGeeks,
but not familiar with any better choice for html in particular.
 
A

akm

Is there a better newsgroup and/or discussion forum that would be better than
this one to find an answer for this question ?
Generally use MajorGeeks, but not familiar with any better choice for Excel
and html in particular.
 
Top