PC_Meister
Board Regular
- Joined
- Aug 28, 2013
- Messages
- 72
Hello,
I am trying to generate a basic Visio flowchart from Excel using VBA. In case there are duplicate values within the same column, no new shape will need to be created, the existing shape will be used. I am showing a sample table with dummy data, and the output flow diagram in Visio. For example, we have A -> M ->N and A -> M -> O, no new "A" and "M" were created, the existing shapes were used as well as another connector from "M" to "O".
The one idea I have in mind, is to remove duplicates from each column, and create the shapes based duplicate free columns, and then go through the original tables with duplicates to properly assign the connectivity of the shapes using connectors. I don't know if that is the best approach. Any help will be much appreciated.Thanks in advance
I am trying to generate a basic Visio flowchart from Excel using VBA. In case there are duplicate values within the same column, no new shape will need to be created, the existing shape will be used. I am showing a sample table with dummy data, and the output flow diagram in Visio. For example, we have A -> M ->N and A -> M -> O, no new "A" and "M" were created, the existing shapes were used as well as another connector from "M" to "O".
The one idea I have in mind, is to remove duplicates from each column, and create the shapes based duplicate free columns, and then go through the original tables with duplicates to properly assign the connectivity of the shapes using connectors. I don't know if that is the best approach. Any help will be much appreciated.Thanks in advance
