Shape Report for all pages that specifies the sheet name for each shape

Started by ketyszko, June 28, 2016, 06:02:01 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

ketyszko

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.


wapperdude

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
Visio 2019 Pro