Hi ,
I have a visio drawing in which i created a box shape with text inside describing the shape and also small boxes for its ports with numbering for the ports - the shape is grouped .
Simmilarly i have other shapes - each with its own text and ports .
Now the shapes are connected with connectors between ports .
The goal : to export/print a list that will include from device/shape port number to device/shape port number
Kindly if you can assist with VBA code for the solution .
see example attached :
I searched for solution , but need a simple readable solution
Thanks
yoram
I did same solution about 8 years ago and share there...
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
Hi ,
Thanks a lot .
It was exactly what i wanted !!!
Could you also guide me , how can i add my own shapes to the document (i assume as Master shapes )
Yoram
In that example i have 3 level structure:
- On-board ports;
- Port in SFP-module in SFP-slot of Cisco C3750G-24TS;
- Port in SFP-module in 24-ports card in Cisco 7606.
You need create table of connections only for on-board ports ?
Hi ,
With your permission, i would be glad to cover all options that you have as well
Thanks
Yoram
I created these masters many years ago ! And use it short time (few months). I forget details.
I can remember only that each port must have 3 shape data properties
(https://i.ibb.co/984DXgv/port.png)
My code read these properties and write to Excel table.
Sorry just now i dont have enougth time for investigate this :(
No problem .
Thanks a lot for your help
Cheers !
Quote from: Surrogate on November 10, 2020, 04:29:19 AM
I did same solution about 8 years ago and share there...
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
Unfortunately this solutions seems not to work anymore... Too bad...
Quote from: tepebox on August 20, 2021, 11:59:11 AM
Unfortunately this solutions seems not to work anymore...
Can you describe what wrong ?
PS
Quote from: tepebox on August 20, 2021, 12:09:41 PM
I think this is a very basic request and I found some more "fancy" implementations for network diagrams etc.
Yes, this solution not universal.