Visio Guy

Visio Discussions => Programming & Code => Topic started by: ketyszko on June 28, 2016, 06:02:01 PM

Title: Shape Report for all pages that specifies the sheet name for each shape
Post by: ketyszko on June 28, 2016, 06:02:01 PM
I need an excel report that combs through all pages and displays all the Shape text (i figured this part out using the Shape Reports Functionality) along with the corresponding sheet name the shape is located on. Does anyone have suggestions, I've read about adding Shape Data but there are upwards of 100 sheets with numerous shapes so would need to automate the assignment of Shape Data if possible.

Title: Re: Shape Report for all pages that specifies the sheet name for each shape
Post by: wapperdude on June 28, 2016, 07:10:21 PM
Take a look at this post:  http://visguy.com/vgforum/index.php?topic=7302.msg30745;topicseen#msg30745

The file is readily modifiable to loop thru all pages in a document, and to include the page name in the "report".

A similar file exists here, but doesn't push the results back into Visio:  http://visguy.com/vgforum/index.php?topic=7297.msg30734;topicseen#msg30734

Note, as setup, these only examine shape data as stored in the shapesheet.

HTH
Wapperdude