Excel link + Automatically connect shapes

[Aleks]

Hi there,

I'm currently building a map of my company applications (more than 90
applications).
I use an Excel to store informations such as Applications name, purpose, etc.
I also have a Worksheet that store informations about applications that are
calling other (web service, direct database, file, etc.).

Know, I want to have a visual representations of these informations.

I succeeded importing these data in visio and showing applications.

But I failed to represent links between applications.

Do you have any idea how I could do that automatically ?

Thank you.

 

[AlEdlund]

you might check this out

http://www.visguy.com/2009/04/08/path-analysis-in-visio/

I specifically put some example code in for this type of problem (comes up a
lot when you move data centers)
al