How do I create a visio 2003 drawing from excel spreadsheet

S

Sharma

Hi,
I attempting to create a block diagram of connections in Visio 2003 from
Excel 2003. I need to draw some boxes identified with certain connectors and
connector lengths. I have data in Excel 2003 spreadsheet in following format:

Module ! Size ! Dependency_1 ! Lead_time_1 ! Dependency_2 ! Lead_time_2
!....!Dependency_n ! Lead_time_n !

.... where dependency = connection between two modules;
.... and Lead_time = lenght of the connector.
......Dependnecy_n= name of module mentioned in "Module" column

With help of various postings on blogs and msdn database, I have now created
one stencil with circle as master.0. I have also linked the circle (master.0)
to the excel data. Now, when I draw the diagram, I get circles drawn for each
modules defined in the excel "Module" column. Also, each circle contains the
data specified for Module row.

However, I have not been able to get the connection between modules working.

I am sure, I am missing something....but what... I dont know. I have tried
searching various examples, but havent made any progress.

Can someone please help me.

Thanks in advance,
Sharma
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vision 2003 drawing from Excel 2003 spreadsheet 3
Drawing visio shapes from Excel data 1
How do I import an Excel spreadsheet to a Visio 2003 network diagr 1
Visio Excel Link 1
Custom properties contents disappear upon reload of Visio document 2
Visio 2003: Import data from Excel? 5
How do I draw a circle, centered on the end point of a line in Vis 2
Create visio diagram from MS Excel data 5

Top