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

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 ?

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 ?

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

In my tests when I used the URL
http://www.rowing.biddulph.btinterne...s/sheet002.htm,
although the address line in the browser showed
http://www.rowing.biddulph.btinterne...priv/Book1.htm, the page was
opened at the sheet designated by
http://www.rowing.biddulph.btinterne...s/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.
--
David Biddulph

akm wrote:
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 ?


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 ?

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

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.btinterne...s/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.

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



"David Biddulph" wrote:

In my tests when I used the URL
http://www.rowing.biddulph.btinterne...s/sheet002.htm,
although the address line in the browser showed
http://www.rowing.biddulph.btinterne...priv/Book1.htm, the page was
opened at the sheet designated by
http://www.rowing.biddulph.btinterne...s/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.
--
David Biddulph

akm wrote:
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 ?


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 ?

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

Ah, that's worrying. I naively assumed that because
http://www.rowing.biddulph.btinterne...s/sheet002.htm
got me to sheet 2, the same would apply to other sheets, but I see that
http://www.rowing.biddulph.btinterne...s/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.
--
David Biddulph

akm wrote:
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.btinterne...s/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.


In my tests when I used the URL
http://www.rowing.biddulph.btinterne...s/sheet002.htm,
although the address line in the browser showed
http://www.rowing.biddulph.btinterne...priv/Book1.htm, the page
was opened at the sheet designated by
http://www.rowing.biddulph.btinterne...s/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. --
David Biddulph

akm wrote:
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 ?


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 ?

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

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.
--
Thanks again for your help !
OS: XP, SP-2 (Office2003)



"David Biddulph" wrote:

Ah, that's worrying. I naively assumed that because
http://www.rowing.biddulph.btinterne...s/sheet002.htm
got me to sheet 2, the same would apply to other sheets, but I see that
http://www.rowing.biddulph.btinterne...s/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.
--
David Biddulph

akm wrote:
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.btinterne...s/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.


In my tests when I used the URL
http://www.rowing.biddulph.btinterne...s/sheet002.htm,
although the address line in the browser showed
http://www.rowing.biddulph.btinterne...priv/Book1.htm, the page
was opened at the sheet designated by
http://www.rowing.biddulph.btinterne...s/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. --
David Biddulph

akm wrote:
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 ?


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 ?