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

[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