Author Topic: Network diagram link "connected to" Value  (Read 355 times)

0 Members and 1 Guest are viewing this topic.

leblanda

  • Newbie
  • *
  • Posts: 1
Network diagram link "connected to" Value
« on: July 14, 2022, 12:47:57 PM »
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

  • Hero Member
  • *****
  • Posts: 1636
    • ShapeSheet™ Knowledge Base
Re: Network diagram link "connected to" Value
« Reply #1 on: July 14, 2022, 01:54:57 PM »
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!
« Last Edit: July 14, 2022, 02:01:52 PM by Surrogate »

Yacine

  • Hero Member
  • *****
  • Posts: 3000
Yacine