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 RobertsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Office Productivity

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.