If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Hyperlink from Excel to specific page in Visio Drawing
I am trying to link a cell from an Excel Spreadsheet to a specific page in a
Visio Drawing and can only create a hyperlink to the main (first page). How do I link to other pages without having to navigate through the first page. I have set up a Navigation Tree on the first page, but I would rather just go to the page directly. |
#2
|
|||
|
|||
Hyperlink from Excel to specific page in Visio Drawing
Hello Amy,
Add your hyperlink in the normal way and then add a hash character follwed by the respective page name. For example: C:\Documents and Settings\UserName\Desktop\Drawing1.vsd#Page-2 Best regards John John Goldsmith www.visualSignals.typepad.co.uk www.visualSignals.co.uk "Amy" wrote in message ... I am trying to link a cell from an Excel Spreadsheet to a specific page in a Visio Drawing and can only create a hyperlink to the main (first page). How do I link to other pages without having to navigate through the first page. I have set up a Navigation Tree on the first page, but I would rather just go to the page directly. |
#3
|
|||
|
|||
Hyperlink from Excel to specific page in Visio Drawing
Tried this but it won't work. Here is some more info on the problem. I save
the vsd files as a web page so that they can be used for our online documentation. I have an excel sheet with all of the servers listed and would like to just jump right to the specific page in the visio drawing. This is the link that I have right now. http://netdocs.mine.com/winserverCAB1.htm#EXCHN01 When I click on this from the excel sheet it only loads the winserverCAB1.htm part not the specific page in this drawing. The web address shows it as I have typed above, just on the first page instead of where I want it. Is it possible to do it the way I have it set up? It has to be a web page because not everyone will have Visio installed on their machine. "John Goldsmith" wrote: Hello Amy, Add your hyperlink in the normal way and then add a hash character follwed by the respective page name. For example: C:\Documents and Settings\UserName\Desktop\Drawing1.vsd#Page-2 Best regards John John Goldsmith www.visualSignals.typepad.co.uk www.visualSignals.co.uk "Amy" wrote in message ... I am trying to link a cell from an Excel Spreadsheet to a specific page in a Visio Drawing and can only create a hyperlink to the main (first page). How do I link to other pages without having to navigate through the first page. I have set up a Navigation Tree on the first page, but I would rather just go to the page directly. |
#4
|
|||
|
|||
Hyperlink from Excel to specific page in Visio Drawing
Hello Amy,
Ah, a web page. I'd assumed you were refering to a Visio document. Anyway, I'll take a look at this and get back to you. Best regards John John Goldsmith www.visualSignals.typepad.co.uk www.visualSignals.co.uk "Amy" wrote in message ... Tried this but it won't work. Here is some more info on the problem. I save the vsd files as a web page so that they can be used for our online documentation. I have an excel sheet with all of the servers listed and would like to just jump right to the specific page in the visio drawing. This is the link that I have right now. http://netdocs.mine.com/winserverCAB1.htm#EXCHN01 When I click on this from the excel sheet it only loads the winserverCAB1.htm part not the specific page in this drawing. The web address shows it as I have typed above, just on the first page instead of where I want it. Is it possible to do it the way I have it set up? It has to be a web page because not everyone will have Visio installed on their machine. "John Goldsmith" wrote: Hello Amy, Add your hyperlink in the normal way and then add a hash character follwed by the respective page name. For example: C:\Documents and Settings\UserName\Desktop\Drawing1.vsd#Page-2 Best regards John John Goldsmith www.visualSignals.typepad.co.uk www.visualSignals.co.uk "Amy" wrote in message ... I am trying to link a cell from an Excel Spreadsheet to a specific page in a Visio Drawing and can only create a hyperlink to the main (first page). How do I link to other pages without having to navigate through the first page. I have set up a Navigation Tree on the first page, but I would rather just go to the page directly. |
#5
|
|||
|
|||
Hyperlink from Excel to specific page in Visio Drawing
A HTML Tag "Anchor" does exist.
"Amy" wrote: Tried this but it won't work. Here is some more info on the problem. I save the vsd files as a web page so that they can be used for our online documentation. I have an excel sheet with all of the servers listed and would like to just jump right to the specific page in the visio drawing. This is the link that I have right now. http://netdocs.mine.com/winserverCAB1.htm#EXCHN01 When I click on this from the excel sheet it only loads the winserverCAB1.htm part not the specific page in this drawing. The web address shows it as I have typed above, just on the first page instead of where I want it. Is it possible to do it the way I have it set up? It has to be a web page because not everyone will have Visio installed on their machine. "John Goldsmith" wrote: Hello Amy, Add your hyperlink in the normal way and then add a hash character follwed by the respective page name. For example: C:\Documents and Settings\UserName\Desktop\Drawing1.vsd#Page-2 Best regards John John Goldsmith www.visualSignals.typepad.co.uk www.visualSignals.co.uk "Amy" wrote in message ... I am trying to link a cell from an Excel Spreadsheet to a specific page in a Visio Drawing and can only create a hyperlink to the main (first page). How do I link to other pages without having to navigate through the first page. I have set up a Navigation Tree on the first page, but I would rather just go to the page directly. |
#6
|
|||
|
|||
Hyperlink from Excel to specific page in Visio Drawing
John, Thanks for the help!
Just to clear things up the web page is a visio drawing saved as a web page. We use this method to create topologies of our network and it would be great if I could just link to a specific page in the visio web page. Thanks again! "John Goldsmith" wrote: Hello Amy, Ah, a web page. I'd assumed you were refering to a Visio document. Anyway, I'll take a look at this and get back to you. Best regards John John Goldsmith www.visualSignals.typepad.co.uk www.visualSignals.co.uk "Amy" wrote in message ... Tried this but it won't work. Here is some more info on the problem. I save the vsd files as a web page so that they can be used for our online documentation. I have an excel sheet with all of the servers listed and would like to just jump right to the specific page in the visio drawing. This is the link that I have right now. http://netdocs.mine.com/winserverCAB1.htm#EXCHN01 When I click on this from the excel sheet it only loads the winserverCAB1.htm part not the specific page in this drawing. The web address shows it as I have typed above, just on the first page instead of where I want it. Is it possible to do it the way I have it set up? It has to be a web page because not everyone will have Visio installed on their machine. "John Goldsmith" wrote: Hello Amy, Add your hyperlink in the normal way and then add a hash character follwed by the respective page name. For example: C:\Documents and Settings\UserName\Desktop\Drawing1.vsd#Page-2 Best regards John John Goldsmith www.visualSignals.typepad.co.uk www.visualSignals.co.uk "Amy" wrote in message ... I am trying to link a cell from an Excel Spreadsheet to a specific page in a Visio Drawing and can only create a hyperlink to the main (first page). How do I link to other pages without having to navigate through the first page. I have set up a Navigation Tree on the first page, but I would rather just go to the page directly. |
#7
|
|||
|
|||
Hyperlink from Excel to specific page in Visio Drawing
On Wed, 23 Apr 2008 05:23:00 -0700, Amy
wrote: John, Thanks for the help! Just to clear things up the web page is a visio drawing saved as a web page. We use this method to create topologies of our network and it would be great if I could just link to a specific page in the visio web page. As Philippe indicated, you need to set some name tag in the HTML a name="page1"Page1/a then in the link add a #page1 -- Regards, Paul Herber, Sandrila Ltd. DFD for Visio http://www.gane-sarson.sandrila.co.uk/ |
#8
|
|||
|
|||
Hyperlink from Excel to specific page in Visio Drawing
I know how to do regular Anchor tags in a regular HTML document. A visio
Drawing saved as an web page is not the same. It allows a person to view the drawing in an internet browser without have to have Visio installed and allows for navigation through the different pages. I have a visio drawing with 12 pages and each page has a different server on it. I have an excel sheet with the severs listed with other informaiton and I want to be able to hyperlink from excel cell to the specific Visio page. The problem is that when I make the link it will only open to the first page of the visio drawing(saved as a web page) not the specific page in the visio drawing (saved as a webpage) I have tried myvisio.htm#page2 and it still just opens to myvisio.htm (the first page in the drawing). Do I have to create anchors(?) on each of the visio drawings pages before it will recognize them (hence it always opens on the first page regardless of which subpage I add to the tail of the address) and open them directly? "Paul Herber" wrote: On Wed, 23 Apr 2008 05:23:00 -0700, Amy wrote: John, Thanks for the help! Just to clear things up the web page is a visio drawing saved as a web page. We use this method to create topologies of our network and it would be great if I could just link to a specific page in the visio web page. As Philippe indicated, you need to set some name tag in the HTML a name="page1"Page1/a then in the link add a #page1 -- Regards, Paul Herber, Sandrila Ltd. DFD for Visio http://www.gane-sarson.sandrila.co.uk/ |
#9
|
|||
|
|||
Hyperlink from Excel to specific page in Visio Drawing
Hello Amy,
The page index in the Save As Web output is set as a variable in the javascript of the default page (ie Drawing1.htm), which in turn sets the correct feed for the drawing frame. You shouldn't need to add an anchor tag, but you will need to add a javascript function to evalute the url as the page loads. I'm going to write this up as a blog over the weekend so I hope that helps in the mean time. Best regards John John Goldsmith www.visualSignals.typepad.co.uk www.visualSignals.co.uk "Amy" wrote in message ... I know how to do regular Anchor tags in a regular HTML document. A visio Drawing saved as an web page is not the same. It allows a person to view the drawing in an internet browser without have to have Visio installed and allows for navigation through the different pages. I have a visio drawing with 12 pages and each page has a different server on it. I have an excel sheet with the severs listed with other informaiton and I want to be able to hyperlink from excel cell to the specific Visio page. The problem is that when I make the link it will only open to the first page of the visio drawing(saved as a web page) not the specific page in the visio drawing (saved as a webpage) I have tried myvisio.htm#page2 and it still just opens to myvisio.htm (the first page in the drawing). Do I have to create anchors(?) on each of the visio drawings pages before it will recognize them (hence it always opens on the first page regardless of which subpage I add to the tail of the address) and open them directly? "Paul Herber" wrote: On Wed, 23 Apr 2008 05:23:00 -0700, Amy wrote: John, Thanks for the help! Just to clear things up the web page is a visio drawing saved as a web page. We use this method to create topologies of our network and it would be great if I could just link to a specific page in the visio web page. As Philippe indicated, you need to set some name tag in the HTML a name="page1"Page1/a then in the link add a #page1 -- Regards, Paul Herber, Sandrila Ltd. DFD for Visio http://www.gane-sarson.sandrila.co.uk/ |
#10
|
|||
|
|||
Hyperlink from Excel to specific page in Visio Drawing
Hello Amy,
Well I've done a quick write up: http://visualsignals.typepad.co.uk/v...o-specifi.html Let me know if this helps or if you have any other questions. Best regards John John Goldsmith www.visualSignals.typepad.co.uk www.visualSignals.co.uk "Amy" wrote in message ... I know how to do regular Anchor tags in a regular HTML document. A visio Drawing saved as an web page is not the same. It allows a person to view the drawing in an internet browser without have to have Visio installed and allows for navigation through the different pages. I have a visio drawing with 12 pages and each page has a different server on it. I have an excel sheet with the severs listed with other informaiton and I want to be able to hyperlink from excel cell to the specific Visio page. The problem is that when I make the link it will only open to the first page of the visio drawing(saved as a web page) not the specific page in the visio drawing (saved as a webpage) I have tried myvisio.htm#page2 and it still just opens to myvisio.htm (the first page in the drawing). Do I have to create anchors(?) on each of the visio drawings pages before it will recognize them (hence it always opens on the first page regardless of which subpage I add to the tail of the address) and open them directly? "Paul Herber" wrote: On Wed, 23 Apr 2008 05:23:00 -0700, Amy wrote: John, Thanks for the help! Just to clear things up the web page is a visio drawing saved as a web page. We use this method to create topologies of our network and it would be great if I could just link to a specific page in the visio web page. As Philippe indicated, you need to set some name tag in the HTML a name="page1"Page1/a then in the link add a #page1 -- Regards, Paul Herber, Sandrila Ltd. DFD for Visio http://www.gane-sarson.sandrila.co.uk/ |
Thread Tools | |
Display Modes | |
|
|