Export relationship information from Visio to Excel

Export relationship information from Visio to Excel

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

date: Fri, 20 Jun 2008 09:01:02 -0700 author: Ivan Salas

Re: Export relationship information from Visio to Excel

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"  wrote in message 
news:6332A594-E4AF-4E8B-BA2D-7A4BC17962B3@microsoft.com...
> 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

date: Fri, 20 Jun 2008 12:23:10 -0500 author: AlEdlund

RE: Export relationship information from Visio to Excel

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?

"Ivan Salas" wrote:

> 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

date: Mon, 23 Jun 2008 08:17:02 -0700 author: Ivan Salas

Re: Export relationship information from Visio to Excel

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

"Ivan Salas"  wrote in message 
news:6D06D79F-72F3-4145-851F-23882AE46CBD@microsoft.com...
> 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?
>
> "Ivan Salas" wrote:
>
>> 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

date: Mon, 23 Jun 2008 11:30:15 -0500 author: AlEdlund

RE: Export relationship information from Visio to Excel

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?

"Ivan Salas" wrote:

> 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

date: Mon, 23 Jun 2008 13:32:05 -0700 author: ldupre

Re: Export relationship information from Visio to Excel

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

"ldupre"  wrote in message 
news:08040911-FEE2-4426-91CF-1CB1C1C432B2@microsoft.com...
> 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?
>
> "Ivan Salas" wrote:
>
>> 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

date: Mon, 23 Jun 2008 19:05:02 -0500 author: AlEdlund

Re: Export relationship information from Visio to Excel

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

"AlEdlund" wrote:

> 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
> 
> "ldupre"  wrote in message 
> news:08040911-FEE2-4426-91CF-1CB1C1C432B2@microsoft.com...
> > 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?
> >
> > "Ivan Salas" wrote:
> >
> >> 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 
>

date: Tue, 24 Jun 2008 11:49:01 -0700 author: Ivan Salas