• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 216
  • Last Modified:

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

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
Jonathan Roberts
Jonathan Roberts
1 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.
Jonathan RobertsAuthor Commented:
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

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now