Import flowchart data wizard

[Myth042]

I am currently using the import wizard to produce several flowcharts of our
multiple systems. Once I have the flowcharts generated, I am manually doing
the following:
a) inserting hyperlinks to tie together the multiple flowcharts and some
Excel spreadsheets.
b) separating the multiple connector lines that are overlapping
c) changing the color of the connector lines to match the type of file
transfer being used for each interface

Can anyone help me automate any or all of the above three tasks?

Also, once completed, we will be using an Oracle database to dynamically
generate the input file to the Visio macro. I am also looking forhelp to
dynamically execute the import macro to generate the flowcharts.

Any and all help is greatly appreciated.

 

[junethesecond]

How would you like to use import method?
Various vba examples may be found in "Visio Information" or any other web
sites.

 

[Myth042]

I'm open to suggestions, but our current thought is to use a web screen to
select the data to be imported. Our process would pull the data from Oracle
and put it in Excel for importing. My first concern is to be able to import
hyperlinks and colors and to have it separate overlapping lines.

We are using Visio 2002 pro. Thank you.

 

[junethesecond]

If on the Visio screen a kind of a,b,c can be made by VBA ,but on the web
browser I am not sure.