Hyperlinking an object in Visio to an Excel worksheet

[ulrich77]

I have created a hierarchy tree in Visio and I would like to hyperlink
shapes to be able to click and it opens up the appropriate worksheet in
Excel. I would then like to be able to click on another shape and open up
another worksheet in the same book. How would I do that?

 

[John Goldsmith]

Hello Ulrich,

To hyperlink to a specific worksheet use the following syntax:

C:\MySpreadsheet.xls#Sheet1!A1

This will open the respective spreadsheet a Sheet 1 with cell A1 selected
using a right-click. (This has the benefit of a single shape being able to
hold multple links.) Subsequent links to other worksheets will just change
the active page.

If you want to replicate the double click behaviour then take a look at this
link that uses the HYPERLINK shapesheet function:

http://blogs.msdn.com/mailant/archive/2004/10/14/242340.aspx

Best regards

John


John Goldsmith
www.visualSignals.co.uk