View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
akm akm is offline
external usenet poster
 
Posts: 19
Default How to make url link to sheet in Excel web page ???

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 ?

--
Thanks again for your help.
OS: XP, SP-2 (Office2003)



"David Biddulph" wrote:

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.
--
David Biddulph

akm wrote:
How to make web browser URL link to one of individual sheets in Excel
workbook saved as web page.
Tried... http://domain/index_files/sheet004.htm
...but no luck.
Ideas ?