Network diagram link "connected to" Value

[leblanda]

We are using Visio 2019 Pro to create network diagram.
I would like to export the a connection list to excel that will include
Cable name source (switch1 port 2) and destination (switch3 port 5)

Anyone know how?

Thanks

[Surrogate]

Anyone know how?

Out-of-box Visio can not do it, but you can write own macro for create that report.

In this attachment you can see drawing with some network devices. You may reconnect dynamic connectors to ports (which you can see above green rectangles).

Macro in this file created table of connections. It create new Excel file named like as "T5_auto_T5_v027.xls", and fill this table there

in this thread you can find code, which was written decade ago
My solution is not universal, because it works ONLY with 'our corporative' network diagram style!

[Yacine]

http://visguy.com/vgforum/index.php?topic=5840.0