How to create shapes and connections by importing excel-file

[Andy O.]

I have an excel file as:

Object-A Object-B connection-1
Object-A Object-C connection-2
Object-B Object-D connection-3

I wish to import it to visio 2003 and let it create shapes for those
"Object-A",..., "Object-D" and link them together by drawing lines (with
those "connection-1",.."Connection-3" names).

How to do it in visio 2003?

Regards
Andy

 

[Andy O.]

Actually what I try to you is something like what this article is about. But
it shows how to do it in the old visio versions that could open *.txt and
*.csv files and those file types are not supported in visio 2003.

http://www.boxesandarrows.com/archives/automating_diagrams_with_visio.php?page=1


_________________________

 

[Andy O.]

Sorry, wrong link:

This is what I try to do, but the instructions does not work fo visio 2003
that does not support csv-files.

http://www.boxesandarrows.com/archives/automating_diagrams_with_visio.php?page=discuss

 

[Bill Morein [MSFT]]

As long as the file is a pure hierarchy, your best bet is to use the Org
Chart Wizard (see
http://office.microsoft.com/en-us/assistance/HA010774641033.aspx).

If the data is not hierarchical, the best bet is probably to use the
Flowchart sample application in the Visio SDK
(http://www.microsoft.com/downloads/...bd-b0bb-46e7-936a-b8539898d44d&displaylang=en).

--
Bill Morein
Office Graphics - Visio
Microsoft Corporation
http://blogs.msdn.com/wmorein

This posting is provided "AS IS" with no warranties, and confers no rights.