Solved

Visio 2013 - How to Extract comments from all shapes on one page and place them in Excel worksheet.

Posted on 2014-03-12
6
1,307 Views
Last Modified: 2016-09-01
I have a diagram with about 200 shapes.  I would like to extract the names of those shapes and the contents of the COMMENTS field.  I would like to place these on an Excel worksheet.

How can I do this?
0
Comment
Question by:brothertruffle880
  • 3
  • 2
6 Comments
 
LVL 30

Accepted Solution

by:
Scott Helmers earned 500 total points
ID: 39924502
The Visio report writer will do that for you quite easily.

Select Review>Shape Reports then step through the wizard, selecting <Displayed Text> as one of the fields you want in your report. Then when you run the report, choose Excel as the output type.
0
 

Expert Comment

by:HvdH62
ID: 41549711
"Displayed text" will not show comments under Review/Shape reports in Visio 2013. Any other solution?
0
 
LVL 30

Expert Comment

by:Scott Helmers
ID: 41550340
I can think of two alternatives:

1) Because the report writer doesn't seem to have direct access to the Comments cell, you can create a Shape Data field or a User cell and then equate it to the Comments cell. After than, just include your Shape Data field or User cell in the report definition.

2) If your shape doesn't already display other text, you could Insert>Field, use a custom formula and set it equal to Comment. That will display the comment text on the shape but will also make it available in a report via the <Displayed Text> field.

Let me know if you need additional help with either technique.
0
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 

Expert Comment

by:HvdH62
ID: 41550580
Hi Scott,
1) Shape data field doesn't see comments. User field is not known in Visio 2013.
2) Nice idea, but 'Comments' is not in the Fields list and thus cannot be added.
Other ideas?
0
 

Expert Comment

by:Ryan M
ID: 41779836
I'm also not having any luck with this and would love suggestions.  Thanks!
0
 
LVL 30

Expert Comment

by:Scott Helmers
ID: 41779991
Suggestion #2 in my reply above does work. This image shows how to insert the Comment field so its contents displays on a shape:commentThen the text of the comment will be available as <Displayed Text> when you are defining a report.

Also, you said that User fields are not known in Visio 2013. They certainly are (they've been in every version of Visio since the beginning). However, they are not accessible via the Visio user interface. You need to learn how to edit the ShapeSheet to work with user cells. To get started with the ShapeSheet you might try part 1 of the "Becoming a Visio Power User" series I recorded for Microsoft Virtual Academy.
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Have you ever created a custom Visio stencil – a collection of your own unique master shapes – and then created a drawing by dragging masters onto the drawing page? Have you then made changes to the stencil master and wondered why the shapes on the …
The ability to add structure to Visio diagrams using containers, lists and callouts is one of my favorite features in Visio 2010. In this article we’ll examine lists. We’ll explore containers and callouts in separate articles. Prior to reading th…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now