We help IT Professionals succeed at work.

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

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
Watch Question

This one is on us!
(Get your first solution completely free - no credit card required)


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
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.