Linking Excel to Visio

[Mark Dullingham]

Is it possible to limk the text box associated with a shape to a cell in ann
excel wrksheet?

 

[Al Edlund]

this was offered by another user (rene)

There were two kb articles describing the steps to set up a link between
Visio and Excel

http://support.microsoft.com/default.aspx?scid=kb;en-us;254591
http://support.microsoft.com/default.aspx?scid=kb;en-us;323451

al

 

[Scott]

At the risk of suggesting an overly simple idea -- in contrast to Al's which
can allow you to build a live, one- or two-way link from Visio to Excel --
you can also hyperlink the Visio shape to a spreadsheet. In fact, you can
link to a specific cell so when the user follows the hyperlink, the
spreadsheet opens with the target cell highlighted.

Note that this doesn't link at the data level; all you're doing is allowing
the user to navigate from the drawing to a specific location in the
spreadsheet.

If this idea sounds useful, look at the Visio help text:

For Visio 2002: Open the Hyperlinks and Web Pages chapter, then open the Web
Pages subchapter.

For Visio 2003: Click on Table of Contents, open the Visio and the Web
chapter, then open the subchapter titled Publishing to the Web.

To link directly to a cell, assign a name to the cell, then use the
Subaddress field in the Visio hyperlink dialog.

 

[Scott]

A correction to my previous post -- I pointed to the wrong subchapters in the
help text. Corrected version is here:

 

[Mark Dullingham]

Thanks everyone

I've realised that I probably should have been a little more specific in my
question.
I have a spreadsheet with links using Dynamic Data Exchange to retrieve
information from an application that uses mdb database files.
What I would like to do is display the data in a specific cell in the
spreadsheet in the text box associated with shapes that I have created or is
it possible to enter an '=' formula like you do in excel to retrieve the
information directly from the other application.
The DDE link in excel looks like this - =the962|IQVALUE!'L13O050R(D). This
returns a text value something like 'AC Unit 1'. This is the information I
would like to display in visio.
Many thanks in advance

 

[Al Gillis]

Thanks Scott, this is a great post! (for Mark and me, anyway!) It was
everything I needed with one tiny exception.

I've named a cell in my spreadsheet, done the "Insert Hyperlink" and edited
the Visio Shapesheet subaddress field to point to that named cell. It works
just as I wanted although after right clicking the shape and selecting the
link from the box I get a cautionary F.U.D. window warning me about viruses.
Any way to avoid that screen and just pull up the spreadsheet with further
ado?

Thanks!

Al