Creating Visio Data flows with Excel data

Started by zero100, August 11, 2017, 02:53:26 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

zero100

Hi everyone

I'd like to create a data flow diagram out of an excel sheet, that contains all necessary information for data flows.

The excel is basically structured like this:

System // Receives data from System.. // Sends data to System..

A // - // B,C

B // A // C

C // A,B // D

etc. (200 Systems)

In the end I'd like to visualize these relationships between the systems in a data flow diagram.
What would you think is the best approach to automatically generate a diagram out of the mentioned raw data?

I am still new to VBA and I'd be thankful for any tips you might have for me.