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!