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
Quote from: leblanda on July 14, 2022, 05:47:57 PM
Anyone know how?
Out-of-box Visio can not do it, but you can write own macro for create that report.
Quote from: Surrogate on February 19, 2013, 10:44:32 AM
In this attachment (http://visguy.com/vgforum/index.php?action=dlattach;topic=4615.0;attach=4690) 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!
http://visguy.com/vgforum/index.php?topic=5840.0