Visio Flowchart from Excel Process Map using VBA

Started by Bartolomeo, September 08, 2019, 06:28:15 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Bartolomeo

Hi, I've found VBA code for Horizontal Swimline on different forum however it doesn't fit to my project. I tried to use Visio macro recorder in order to solve my issues but I got really confused with it and I have two questions.

1. Is there any possibility to create vertical flowchart based on below code (horizontal swimline) ?
2. Is there any way to add column (column I) with color name/color code? I'd like to have marked shapes for example on green/blue/red.

Link to original code: https://www.mrexcel.com/forum/general-excel-discussion-other-questions/865870-create-visio-horizontal-swimlane-excel-activesheet.html
(Can't post the code here because of SQLi71 error).

Nikolay

Visio has now dedicated "Data Visualizer" (it creates diagrams from Excel data). It's pretty flexible. You don't need any code to use it.
To color your shapes, you can use data graphics ("color by value" feature)

The code you posted is pretty obscure, I'd contact the author for explanations.