News:

BB code in posts seems to be working again!
I haven't turned on every single tag, so please let me know if there are any that are used/needed but not activated.

Main Menu

Export /Print Visio shapes and connections to a list

Started by yoram, November 09, 2020, 09:40:26 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

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

#1
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 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


tepebox

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 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

#8
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.

Browser ID: smf (possibly_robot)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 311 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1138KB.
Tokens: post-login.
Cache hits: 13: 0.00168s for 26,723 bytes (show)
Cache misses: 3: (show)
Queries used: 17.

[Show Queries]