Auto generate Application Interface visio diagram from MS Excel

[Greg B. EMC]

I have a list of approximately 300 business applications and all interfacing
applciations for each.

I want to import the data one time and have Visio automatically create a
diagram with one box for each application and draw an arrow to each related
application.

The data is in two columns, "primary application" and "interfaced
application". For example:

PRIMARY APP INTERFACED APP
peoplesoft data warehouse
peoplesoft HR System
peoplesoft finance system
Data warehouse peoplesoft
data warehouse sales system
data warehouse CRM system
data warehouse executive reporting system
data warehouse finance system
etc...

I have Visio 2007. Does anyone have a good way to do this?

 

[Barb Way]

There isn't a built-in tool to do this for you, but if you aren't afraid of
a little programming, you can build your own solution.

For a VBA example, check out this post at the VisioGuy blog :
http://www.visguy.com/2006/09/13/create-visio-flowcharts-programmatically/

If you have Visual Studio (or one of the individual compilers), and want to
get into creating a COM add-in, download the Visio 2007 SDK and look
through the code samples. There is a complete sample to build a COM add-in
which "automates the creation of a flowchart drawing from a Microsoft®
Office Excel® spreadsheet, uses command bars in the Visio user interface,
and publishes the drawing to the Web or to a Microsoft Office Word
document. "

If you haven't built COM add-ins before, I would suggest sticking with
Visguy - Chris is one of our MVPs


Barb Way
Product Support - Visio
Microsoft Corporation
[This posting is provided "As Is" with no warranties, and confers no
rights.]
--------------------
I have a list of approximately 300 business applications and all
interfacing
applciations for each.

I want to import the data one time and have Visio automatically create a
diagram with one box for each application and draw an arrow to each related
application.

The data is in two columns, "primary application" and "interfaced
application". For example:

PRIMARY APP INTERFACED APP
peoplesoft data warehouse
peoplesoft HR System
peoplesoft finance system
Data warehouse peoplesoft
data warehouse sales system
data warehouse CRM system
data warehouse executive reporting system
data warehouse finance system
etc...

I have Visio 2007. Does anyone have a good way to do this?