Export /Print Visio shapes and connections to a list

[yoram]

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

[Surrogate]

I did same solution about 8 years ago and share there...

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

[yoram]

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

[Surrogate]

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 ?

[yoram]

Hi ,

With your permission, i would be glad to cover all options that you have as well

Thanks

Yoram

[Surrogate]

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

My code read these properties and write to Excel table.

Sorry just now i dont have enougth time for investigate this

[yoram]

No problem .
Thanks a lot for your help
Cheers !

[tepebox]

I did same solution about 8 years ago and share there...

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

Unfortunately this solutions seems not to work anymore... Too bad...

[Surrogate]

Unfortunately this solutions seems not to work anymore...

Can you describe what wrong ?
PS

I think this is a very basic request and I found some more "fancy" implementations for network diagrams etc.

Yes, this solution not universal.