Hyperlink from Excel to specific page in Visio Drawing

[Amy]

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.

 

[John Goldsmith]

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]

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]

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

 

[Philippe C.]

A HTML Tag "Anchor" does exist.

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.

 

[Amy]

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!

 

[Paul Herber]

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

 

[Amy]

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?

 

[John Goldsmith]

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

 

[John Goldsmith]

Hello Amy,

Well I've done a quick write up:

http://visualsignals.typepad.co.uk/vislog/2008/04/link-to-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