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

Network Connectivity: Highlighting and Reporting

Started by wapperdude, December 14, 2023, 01:59:23 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

wapperdude

There are a variety of posts on the Forum dealing with shape connectivity and resulting connectivity networks.  A recent post raised the question about highlighting a network starting at some selected shape and focusing on only subsequent additions.  Seemed like an interesting variation to some prior work.  However, I decided on a new approach that was strictly recursive.  The goals were to look at an entire network, or just subsequent additions.  On a large page with multiple, unrelated networks, the ability to single out and highlight seemed like valuable features.  Once such identification is completed, then, the results are presented visually (duh), and captured via ListBox or Excel.  The criteria chosen for subsequentialization is shape ID.  The attached picture presents results of a subsequential examination.

The code is VBA.  Because there are multiple subs called, I chose to declare the variables globally.  That way their values readily pass from one sub to another.  I'm open to alternative approaches. 

It is best to start with black lines, as line color plays an important role in the operation of the code.  There are a lot of comments within the subs.  The Excel file actually grabs the List Box results as it's already nicely formatted.

Enjoy.
Visio 2019 Pro

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: 134 (show)
Files included: 32 - 1207KB. (show)
Memory used: 988KB.
Tokens: post-login.
Cache hits: 13: 0.00143s for 26,764 bytes (show)
Cache misses: 2: (show)
Queries used: 15.

[Show Queries]