Export relationship information from Visio to Excel

[Ivan Salas]

Hello all,

Is there a way to export information regarding relationships from a visio
diagram to an excel spreadsheet?

In addition, is there a way to tell the excel spreadsheet to eliminate or
change a relationship and for that action to be applied onto the visio
diagram?

thanks,
ivan

 

[AlEdlund]

as a general answer I'd have to say "no, not without custom code". You
didn't define what you meant as a relationship.
al

 

[Ivan Salas]

By relationship, I simply mean a link between one object and the other (a
arrow or a line).

What I really want to be able to do is to create a "master diagram" that
contains all the relevant information that I need and then be able to create
other diagrams that are only portions of that master diagram.

When a change is made to the master, I want it to be automatically reflected
in all the other related diagrams. Is that possible?

 

[AlEdlund]

apologies, now the answer get's a little muddied.
export relationships=>you can use the database wizard to save and change
information
automatically be reflected in related diagrams=>custom code (assumption
here is that you might delete/add objects)
al

 

[ldupre]

When I'm using the wizard to import info from an Excel spreadsheet into
Visio, it brings in all of my information correctly; puts subordinates under
the proper executive, etc., however it will not import them in the order that
I type them into the spreadsheet. For example, I have one executive with six
subordinates and it puts the correct subordinates under the correct
executive, but mixes up the order...how do I stop that from happening?

 

[AlEdlund]

by design the tool randomizes the dropping of the objects to improve
performance. you might consider linking the objects (managers/subordinates)
after the drawings has been created using v2007 datalinking.
al

 

[Ivan Salas]

How do you import information from excel to visio?

(by information, I do not mean only text. I mean shape, relationships,
color, font, etc.)

Thanks