Help!

Linking Excel to Visio - help 2

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions RSS
Next:  Changing Shape Names Is Confusing  
Author Message
Mark Dullingham
External


Since: Sep 22, 2006
Posts: 2



PostPosted: Fri Sep 22, 2006 5:58 pm    Post subject: Linking Excel to Visio
Archived from groups: microsoft>public>visio (more info?)

Is it possible to limk the text box associated with a shape to a cell in ann
excel wrksheet?
Back to top
Al Edlund
External


Since: Feb 23, 2004
Posts: 2109



PostPosted: Fri Sep 22, 2006 8:44 pm    Post subject: Re: Linking Excel to Visio [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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


"Mark Dullingham" wrote in
message
> Is it possible to limk the text box associated with a shape to a cell in
> ann
> excel wrksheet?
Back to top
Scott
External


Since: Mar 10, 2006
Posts: 119



PostPosted: Fri Sep 22, 2006 8:58 pm    Post subject: RE: Linking Excel to Visio [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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.

"Mark Dullingham" wrote:

> Is it possible to limk the text box associated with a shape to a cell in ann
> excel wrksheet?
Back to top
Scott
External


Since: Mar 10, 2006
Posts: 119



PostPosted: Fri Sep 22, 2006 9:07 pm    Post subject: RE: Linking Excel to Visio [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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

> For Visio 2002: Open the Hyperlinks and Web Pages chapter, then open the <i>Hyperlinks</i> subchapter.
>
> For Visio 2003: Click on Table of Contents, open the Visio and the Web
> chapter, then open the subchapter titled <i>Using Hyperlinks in Drawings</i>.
Back to top
Mark Dullingham
External


Since: Sep 22, 2006
Posts: 2



PostPosted: Sun Sep 24, 2006 12:52 pm    Post subject: RE: Linking Excel to Visio [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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


'"Scott" wrote:

> A correction to my previous post -- I pointed to the wrong subchapters in the
> help text. Corrected version is here:
>
> > For Visio 2002: Open the Hyperlinks and Web Pages chapter, then open the <i>Hyperlinks</i> subchapter.
> >
> > For Visio 2003: Click on Table of Contents, open the Visio and the Web
> > chapter, then open the subchapter titled <i>Using Hyperlinks in Drawings</i>.
>
Back to top
Al Gillis
External


Since: Oct 08, 2006
Posts: 10



PostPosted: Sun Oct 08, 2006 6:25 pm    Post subject: Re: Linking Excel to Visio [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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


"Scott" wrote in message

> 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.
>
> "Mark Dullingham" wrote:
>
>> Is it possible to limk the text box associated with a shape to a cell in
>> ann
>> excel wrksheet?
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum