Bulk adding Shape Data to all connectors in Visio to export screen tips to excel

Posted on 2014-08-29
Last Modified: 2016-06-12
I am trying to find a Macro that will apply shade data to all my shapes and connectors so that I can export out the tips to excel. I have manually done it for the shapes but there are too many connectors to do this on. I have seen in another post a macro to do this but it didnt seem to work on my document.

I need to insert shape data to ones that do not already have it and then add a label of ="SHAPE TIP" and a value of =Comment to all the newly inserted shape data objects and anything that had shape data but did not have the label and comment. I need this to insert the shape data even if there are no tips as I will export this to excel to find any ones I have missed.

I have added a reduced version of my document for refference. I have tried to play around with macros but to no avail. could someone let me know what the code would need to be. Thanks
Question by:Jonathan Roberts
    LVL 11

    Accepted Solution

    Hi Jon,

    You might be able to get away with manually editing the local master. Go to More Shapes > Show Document Stencil.

    In the Document Stencil, you should see the "Dynamic connector". Double-click the icon and edit the shape inside. All instances of this master in the document will be updated. This is better and more efficient than applying features to every instance.

    If you have a set of Shape Data fields, you can extract them using Shape Data sets (right-click in the Shape Data window), then apply them inside the master.

    Hope this makes sense--lots of jargon, I know.

    Author Comment

    by:Jonathan Roberts
    Wow, that was really simple and not jargony at all. Wish I would have known this before updating all the shapes one at a time.

    Many Thanks

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Suggested Solutions

    Outline Suppose you have some simple text based data in Excel that you would like to display as a PowerPoint presentation. Of course it would be possible to write some fairly complex VBA code that created a new slide for each line of the Excel data…
    Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
    The viewer will learn how to edit text. This includes Font, Spacing, Resizing, Color, and other special text options.
    This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:

    761 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

    11 Experts available now in Live!

    Get 1:1 Help Now