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.

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.

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.

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.

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.

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.

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/

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/

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/

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/